Skip to Content
0
Mar 22, 2019 at 09:17 PM

C4C: cannot find Account > Sales Data > Tier in OData responses

117 Views Last edit Mar 25, 2019 at 05:29 PM 2 rev

We are using OData to attempt to identify an account's Sales Data > Tier given an account ID, but cannot find this field anywhere the OData response for AccountSalesData.

For example, in this sample customer's Sales Data, we see a Tier of yo (this is a free text field and we edited this to be the value).

When we look at it's OData collection here: https://[tenant URL].crm.ondemand.com/sap/c4c/odata/v1/c4codata/AccountCollection(%2700163E03A0701ED28B9DB0247F82301D%27)/AccountSalesData , we do not see Tier in any of the properties. Pasted below is what the response looks like to that query.

In fact, after hours of searching through this and through OData Service Explorer, we cannot find this Tier value anywhere.

Does anyone have suggestions on where to look for it?

Thanks.

(XML response to OData GET from above:

<entry xmlns="http://www.w3.org/2005/Atom" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" m:etag="W/"datetimeoffset'2019-03-22T20%3A37%3A46.5986890Z'"" xml:base="https://[tenant].crm.ondemand.com/sap/c4c/odata/v1/c4codata/"> <id> https://[tenant].crm.ondemand.com/sap/c4c/odata/v1/c4codata/AccountCollection('00163E03A0701ED28B9DB0247F82301D') </id> <title type="text"> AccountCollection('00163E03A0701ED28B9DB0247F82301D') </title> <updated>2019-03-22T21:11:42Z</updated> <category term="c4codata.Account" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme"/> <link href="AccountCollection('00163E03A0701ED28B9DB0247F82301D')" rel="edit" title="Account"/> <link href="AccountCollection('00163E03A0701ED28B9DB0247F82301D')/AccountAddress" rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountAddress" type="application/atom+xml;type=feed" title="AccountAddress"/> <link href="AccountCollection('00163E03A0701ED28B9DB0247F82301D')/AccountAttachment" rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountAttachment" type="application/atom+xml;type=feed" title="AccountAttachment"/> <link href="AccountCollection('00163E03A0701ED28B9DB0247F82301D')/AccountContactRelationship" rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountContactRelationship" type="application/atom+xml;type=feed" title="AccountContactRelationship"/> <link href="AccountCollection('00163E03A0701ED28B9DB0247F82301D')/AccountNotes" rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountNotes" type="application/atom+xml;type=feed" title="AccountNotes"/> <link href="AccountCollection('00163E03A0701ED28B9DB0247F82301D')/AccountRole" rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountRole" type="application/atom+xml;type=feed" title="AccountRole"/> <link href="AccountCollection('00163E03A0701ED28B9DB0247F82301D')/AccountSalesData" rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountSalesData" type="application/atom+xml;type=feed" title="AccountSalesData"/> <link href="AccountCollection('00163E03A0701ED28B9DB0247F82301D')/AccountTeam" rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/AccountTeam" type="application/atom+xml;type=feed" title="AccountTeam"/> <link href="AccountCollection('00163E03A0701ED28B9DB0247F82301D')/ExternalIDMapping" rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/ExternalIDMapping" type="application/atom+xml;type=feed" title="ExternalIDMapping"/> <content type="application/xml"> <m:properties> <d:ObjectID>00163E03A0701ED28B9DB0247F82301D</d:ObjectID> <d:ETag>2019-03-22T20:37:46.5986890Z</d:ETag> <d:RecommendedVisitingFrequency/> <d:AccountFormattedName>3M</d:AccountFormattedName> <d:POBoxDeviatingRegionCode/> <d:POBoxDeviatingRegionCodeText/> <d:RoleCode>CRM000</d:RoleCode> <d:RoleCodeText>Customer</d:RoleCodeText> <d:AccountName>3M</d:AccountName> <d:AccountName2/> <d:AccountName3/> <d:AccountName4/> <d:AccountID>10330</d:AccountID> <d:UUID>00163E03-A070-1ED2-8B9D-B0247F82301D</d:UUID> <d:MarketingLeadIndicator>false</d:MarketingLeadIndicator> <d:OwnerID>E1005</d:OwnerID> <d:PrimaryContactID>1000396</d:PrimaryContactID> <d:PrimaryContactName>Doug Gramler</d:PrimaryContactName> <d:OwnerUUID>00163E03-A070-1EE2-88BA-39174566D0B3</d:OwnerUUID> <d:OwnerFormattedName>Kate Jacob</d:OwnerFormattedName> <d:ChangedOn>2019-03-22T20:37:46.5986890Z</d:ChangedOn> <d:DUNS/> <d:CreatedOn>2012-11-12T18:05:21.3017610Z</d:CreatedOn> <d:CountyName/> <d:StatusCode>2</d:StatusCode> <d:StatusCodeText>Active</d:StatusCodeText> <d:ABCClassificationCode>B</d:ABCClassificationCode> <d:ABCClassificationCodeText>B-Account</d:ABCClassificationCodeText> <d:LegalFormCode/> <d:LegalFormCodeText/> <d:NielsenID/> <d:NielsenIDText/> <d:ContactPermissionCode/> <d:ContactPermissionCodeText/> <d:CorrespondenceLanguageCode>EN</d:CorrespondenceLanguageCode> <d:CorrespondenceLanguageCodeText>English</d:CorrespondenceLanguageCodeText> <d:PreferredCommunicationMediumTypeCode/> <d:PreferredCommunicationMediumTypeCodeText/> <d:Phone>+1 (651) 733-1110</d:Phone> <d:Email>doug.gamoff@3M.com</d:Email> <d:Fax>+1 (651) 733-1111</d:Fax> <d:Mobile/> <d:Web>www.3m.com</d:Web> <d:AdditionalStreetPrefixName/> <d:AdditionalStreetSuffixName/> <d:BuildingID/> <d:CareOfName/> <d:CityName>St. Paul</d:CityName> <d:CountryCode>US</d:CountryCode> <d:CountryCodeText>United States</d:CountryCodeText> <d:DistrictName/> <d:HouseID>3</d:HouseID> <d:POBoxDeviatingCityName/> <d:POBoxDeviatingCountryCode/> <d:POBoxDeviatingCountryCodeText/> <d:POBoxID/> <d:POBoxPostalCode/> <d:POBoxPostalCodeText/> <d:StreetName>Center</d:StreetName> <d:StreetPostalCode>55144</d:StreetPostalCode> <d:StreetPostalCodeText/> <d:StreetPrefixName/> <d:StreetSuffixName/> <d:TaxJurisdictionCode/> <d:TaxJurisdictionCodeText/> <d:TimeZoneCode>CST</d:TimeZoneCode> <d:TimeZoneCodeText>(UTC-06:00) Central Time (Dallas, Manitoba)</d:TimeZoneCodeText> <d:CategoryCode>2</d:CategoryCode> <d:CategoryCodeText>Organization</d:CategoryCodeText> <d:RegionCode>MN</d:RegionCode> <d:RegionCodeText>Minnesota</d:RegionCodeText> <d:IndustryCode>44</d:IndustryCode> <d:IndustryCodeText>Retail trade</d:IndustryCodeText> <d:CreatedBy>Eddie Smoke</d:CreatedBy> <d:ChangedBy>John Smith</d:ChangedBy> </m:properties> </content> </entry>

Attachments