SAP Knowledge Base Article - Public

2984125 - How To Get the Visit Score And Surveys From Perfect Store Visits Using OData


You want to retrieve Visit Score and Surveys in Perfect Store Visits using OData.


SAP Cloud for Customer


The field "This Visit Score" is available in the OData collection StoreValuationCollection, as field TotalScoreValue (Total score value).

For visits of type Perfect Store, ValuationCollection survey instances have to be reached differently because Survey is not directly linked to visits in this scenario. The association by which Survey is linked to Perfect Store Visits is:

Visit > StoreValuation > SellingPointValuation > Surveys.

Below, there are OData calls needed to reach out to Surveys:

1. Call StoreValuationCollection using Visit ID as ReferenceVisitID:

https://<myTenantURL>/sap/c4c/odata/v1/c4codataapi/StoreValuationCollection?$filter=ReferenceVisitID eq '<Visit ID>'

2. Call SellingPointValuation using StoreValuationCollection Object ID:

https://<myTenantURL>/sap/c4c/odata/v1/c4codataapi/StoreValuationCollection('<StoreValuationCollection ObjectID>')/SellingPointValuation

3. Call Surveys using SellingPointValuationCollection (This has ValuationCollectionUUID -> Runtime instance of Survey):


See Also

2330688 - How to Use Methods And Filters in OData Services


Perfect Store Visit, Visit Score, Survey, OData collection. , KBA , perfect store visit , visit score , survey , odata collection , LOD-CRM-INT-API , OData API (C4C Only) , LOD-LE-PSP , Perfect Store , How To


SAP Cloud for Customer core applications all versions