Hi,
I need to post many rows to an API and rather than individually loop through each record I was wondering if I can dynamically create the request body.
My data or QueryList to POST is set up in the following way :
ID DESC
xxxxxxxx Blue Buckets
aaaaaaa Red Buckets
rrrrrrrrrrrr Green Buckets
My REST connection when manually configured resembles this:
CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url=https://xxxx.com/queryapi.php;timeout=30;method=POST;requestBody={
%3Query%3:
{
%3Key%3: %xxxxxxxxxxxxxxxxxxxxx%3
},
%3QueryListList%3: {
%31%3: %3xxxxxxxx,Blue Buckets%3,
%31%3: %3aaaaaaa,Red Buckets%3,
%31%3: %3rrrrrrrrrrrr,Green Buckets%3
}
}
I have about 500 values to pass to the API service. Rather than manually build the request body - is there a dynamic solution I could utilise? Also, the QueryList will most likely change on a daily basis so the more automation we can build in the better.
Many thanks,
Phil
