Dynamic Filter for CPI

264 Views Asked by At

Need to make the country dynamic in the query.

Current Query:
$top=4&$select=CustomerID,CompanyName,Country&$filter=Country eq 'Italy'

The country 'Italy' should be dynamically picked up from the header.

  • Country field in header: Country field in header
  • The output XML is showing the country value: The output XML is showing the country value

Tried changing the query to:
$top=4&$select=CustomerID,CompanyName,Country&$filter=Country eq ${in.header.country}. This gives a error and doesn't work.

Tried changing the query to:
$top=4&$select=CustomerID,CompanyName,Country&$filter=Country eq ${in.header.country}. This gives a error and doesn't work.

Expect the data to be filtered based on country.

0

There are 0 best solutions below