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

[Former Member]

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>

[sathya_k5]

Hi Jason,

Can you check in the Field definition you marked the field for Odata service.

To do this In master-layout->field definition-> go to odata services tab. Check the check box for customer and c4codata.

Let me know if this helps, we can look further to see if any other issue.

[Former Member]

Sathyasekar,

Thank you for the reply.

Where do I find this interface? How did you get here? I don't understand what "master-layout->field definition-> go to odata services tab" means.

Thank you.

[Former Member]

Update: we were able to find the UI that you laid out. And after checking the boxes, the field now appears in the OData response.

Thank you!