How to query on extension field on std REST API of Sales Cloud V2 using $filer criteria

[suchita_phulkar]

Hi,

I have added an extension field using extensibility in Sales Cloud Version 2 in Sales Territory Service.

As we know, the field gets added to the Service API automatically, and when I do a GET on the API with $filter some std. field. I get the response and can see my custom added field in extensions node too;

However, when I try to query on my extension field's value, I am getting Error. It seems I am writing it wrong ? 

My query is structured as follows:

https://myXXXXXXXXX.cloud.sap/sap/c4c/api/v1/sales-territory-service/salesTerritories?$filter=ZCUST_... eq '123'

Since extensions is a node I see on response, I also tried

https://myXXXXXXXXX.cloud.sap/sap/c4c/api/v1/sales-territory-service/salesTerritories/extensions?$fi... eq '123'

Both cases, I am getting errors related to query structure.

Can someone please help me know how the query to be structured ?

Thanks,

Suchita

[KoenLabie · Accepted solution]

Hi

you should use:

?$filter=extensions/ZCUST_FIELD eq '123'

Koen

[suchita_phulkar · Accepted solution]

Thank you so much Koen !