在azure中检索Salesforce Connector中的关联对象列

本文介绍了在azure中检索Salesforce Connector中的关联对象列的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 是否有任何选项可以使用azure salesforce connector的 选择查询选项检索相关对象字段。 我尝试使用Azure salesforce连接器在salesforce中引用相关对象的属性。但它抛出以下错误   错误 " message"： "字段'Account.Name'不属于'联系'表格。   查询 从联系人中选择Id，Account.Name 解决方案 当您检索对象类型"联系人"时您将获得一个响应json的联系方式以及参考对象的ID，如账户ID，所有者ID等。 您获得的错误预计为 Account.Name 不是在对象类型"联系人"中定义的属性 在检索对象类型时请参阅示例json响应正文""联系" " body"：{" @ odata.context"：" https：// salesforce-sea.azconn-sea.p.azurewebsites.net/v2 / 元数据＃数据集（ '缺省'）/表（ '联系人'）/项目/ entity"，" @ odata.etag"：""，" ItemInternalId"：" fbb24015-XXXX-XXXX-b886-10832ba94643"，" Id"：" 0030o0XXXXXy5RAAS"，" IsDeleted"：false，" MasterRecordId"：null， " AccountId"：" 0010o0XXXXa5kAAB"， " LastName"：" Barr"，" FirstName"：" Tim"，" ; Salutation"：" Mr."，" Name"：" Some Name"，" OtherStreet"：null，" OtherCity"：null，" OtherState" ;: null，" OtherPostalCode"：null，" OtherCountry"：null，" OtherLatitude"：null，" OtherLongitude" ：null，" MailingStreet"：" Some Address"，" MailingCity"：null，" MailingState"：null，" MailingPostalCode"：null ，" MailingCountry" ;: null，" MailingLatitude"：null，" MailingLongitude"：null，" Phone"："（312）596 -1000"，" Fax"："[phone]"，" MobilePhone"："[phone]"，" HomePhone" ：null，" OtherPhone" ;: null，" AssistantPhone"：null，" ReportsToId"：null，" Email"：" abc @ xyz .com"，" Title"：" SVP，Administration and Finance"，" Department"：" Finance"，" AssistantName"：null，"LeadSource"："外部推荐"，"Birthdate"：" 1952-09-06"，"描述" ;: null，" OwnerId"： "0050oxxxxirhFAAR"，"CreatedDate"："2019-01-29T10：56：50Z"，"CreatedById"："0050o0xxxx0VirhFAAR"，"LastModifiedDate"： " 2019-01-29T10：56：50Z& ";，""LastModifiedById"："0050o0xxxxVirhFAAR"，"b $ b""SystemModstamp"："2019-01-29T10：56：50Z"，"LastActivityDate"：null， " LastCURequestDate" ;: null，" LastCUUpdateDate"：null，" LastViewedDate"：null，" LastReferencedDate"：null，" EmailBouncedReason"：null，" EmailBouncedDate"：null，" IsEmailBounced"：false，" PhotoUrl"：" / services / images / photo / 0030XXXX5RAAS"，" Jigsaw" ;: null，" JigsawContactId"：null，" CleanStatus"：" Pending"，" Level__c"：" Secondary"，" Languages__c"：" English" } 如果您想要检索帐户名称，您必须检索 帐户对象，需要传递从 通讯录对象的响应正文中检索到的帐户ID。请参阅以下屏幕截图供您参考： 如果您与上述人员不同，请分享您的洛杉矶设计师的截图。 Is there any option to retrieve related object fields with azure salesforce connector’sselect query option.I have tried to refer attributes of related object in salesforce using Azure salesforce connector. But it is throwing following error Error"message": "The field 'Account.Name' is not part of the 'Contact' table. QuerySelect Id,Account.Name from contact 解决方案 When you retrieve the Object Type "Contacts" you will get a response json with the contact details as well as the ID's of the reference object like Account ID , Owner ID etc.The error you are getting is expected as the Account.Name is not a property defined in the Object Type "Contacts "See the sample json response body when retrieving Object Type "Contact""body": { "@odata.context": "https://salesforce-sea.azconn-sea.p.azurewebsites.net/v2/metadata#datasets('default')/tables('Contact')/items/entity", "@odata.etag": "", "ItemInternalId": "fbb24015-XXXX-XXXX-b886-10832ba94643", "Id": "0030o0XXXXXy5RAAS", "IsDeleted": false, "MasterRecordId": null, "AccountId": "0010o0XXXXa5kAAB", "LastName": "Barr", "FirstName": "Tim", "Salutation": "Mr.", "Name": "Some Name", "OtherStreet": null, "OtherCity": null, "OtherState": null, "OtherPostalCode": null, "OtherCountry": null, "OtherLatitude": null, "OtherLongitude": null, "MailingStreet": "Some Address", "MailingCity": null, "MailingState": null, "MailingPostalCode": null, "MailingCountry": null, "MailingLatitude": null, "MailingLongitude": null, "Phone": "[phone]", "Fax": "[phone]", "MobilePhone": "[phone]", "HomePhone": null, "OtherPhone": null, "AssistantPhone": null, "ReportsToId": null, "Email": "[e-mail]", "Title": "SVP, Administration and Finance", "Department": "Finance", "AssistantName": null, "LeadSource": "External Referral", "Birthdate": "1952-09-06", "Description": null, "OwnerId": "0050oxxxxirhFAAR", "CreatedDate": "2019-01-29T10:56:50Z", "CreatedById": "0050o0xxxx0VirhFAAR", "LastModifiedDate": "2019-01-29T10:56:50Z", "LastModifiedById": "0050o0xxxxVirhFAAR", "SystemModstamp": "2019-01-29T10:56:50Z", "LastActivityDate": null, "LastCURequestDate": null, "LastCUUpdateDate": null, "LastViewedDate": null, "LastReferencedDate": null, "EmailBouncedReason": null, "EmailBouncedDate": null, "IsEmailBounced": false, "PhotoUrl": "/services/images/photo/0030XXXX5RAAS", "Jigsaw": null, "JigsawContactId": null, "CleanStatus": "Pending", "Level__c": "Secondary", "Languages__c": "English" }If you want to retrieve the Account Name you have to retrieve theAccounts object and need to pass the Account ID retrieved from the response body of theContacts Object. See the below screenshot for your reference:If you are anything different than above, please share the screenshots of your LA designer. 这篇关于在azure中检索Salesforce Connector中的关联对象列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！