Hi Experts,
I am trying to use SAP Build-Apps and i am using SAP BTP Destination Rest API integration. I have defined a destination which connects to the API URL in the SAP BTP Cockpit and we are trying to use SAP BTP Destination rest api integration as below :

We specified the query path for the list query as below and used formula to specify the query path as below:

When we place the query and test this as below so that we can use the response to set the schema, we get an error:

Response is 500:

Any idea on this one. I am sure we are trying to do something wrong here and not getting any SAP documentation also on this part. If anyone has encountered this issue or had a way to overcome this in SAP Build apps, can you please let us know.
Some help content that i tried to refer and followed is as below:
https://answers.sap.com/questions/13822459/relative-path-and-query-on-destination-api-rest-in.html
https://answers.sap.com/questions/13822459/relative-path-and-query-on-destination-api-rest-in.html
Thanks
Tirthankar