Dynamically build REST request body

[prees959]

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