Sage REST API - Detail facet example with linked table, i.e: How to concatenate two field to get the details of the record

Question

When I try to get all the fields of SINVOICED table using REST API "Query" facet. I am not getting all the fields of all the records, in some case that filed has a collection of data(Array of data). So I tried to achieve this with "Detail" facet, for that I need to pass the identifier as a parameter. If the table has a single identifier means I can parse the ID and get it. In case, the table has a combination of two fields means I don't know "How to parse the parameter as a single ID in the API URL".

Example I tried: <sage-api-url>api1/x3/erp/<instance>/YSINVOICED('<NUM>' + '<SIDLIN>')?representation=YSINVOICED.$details

In this example, I cannot the record with this URL which I used "+" as concatenator.

Can anyone please help me to solve this?

Luis Moreira · Accepted Answer

Try the ~ character for example FCL~1

Luis Moreira · Answer

Try using ~ . as in FCL~1. 
 Here is one bespoke i did you can take as an example, take a look at the position of the ' ' , hope it helps: 
 http://trax3ion-sagex3v11.northeurope.cloudapp.azure.com:8124/api1/x3/erp/TRAX3ION2/ZITMCOST('00011~00001~1~1')?REPRESENTATION=ZITMCOST.$DETAILS 
 Cheers!

Sage X3

Sage REST API - Detail facet example with linked table, i.e: How to concatenate two field to get the details of the record

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING