1_
12 years agoOccasional Contributor
Creating a REST JSON PUT from Excel data not working
I am using PRO and attempting to form a REST JSON request from an Excel DataSource.
I have no problems using SOAP and a form - it loads the data and runs through the loop creating and sending many PUT Requests.
No Groovy scripts required.
I thought it would be simple to do the same with a REST/JSON also without Groovy.
I've entered this into the Request 'window' with a Media-Type of 'application/json' - expecting the Data to be inserted as it loops through the Excel DataSource:
{"merchid":"${DataSource#merchid}","accttype":"${DataSource#accttype}","account":"${DataSource#account}"}
I've also created a Form (as done with SOAP).
But, the data is not getting inserted into the JSON request:
Wed Mar 12 16:45:51 EDT 2014:DEBUG:>> "{"merchid":"","accttype":"","account":"","\n]"
I have no problems using SOAP and a form - it loads the data and runs through the loop creating and sending many PUT Requests.
No Groovy scripts required.
I thought it would be simple to do the same with a REST/JSON also without Groovy.
I've entered this into the Request 'window' with a Media-Type of 'application/json' - expecting the Data to be inserted as it loops through the Excel DataSource:
{"merchid":"${DataSource#merchid}","accttype":"${DataSource#accttype}","account":"${DataSource#account}"}
I've also created a Form (as done with SOAP).
But, the data is not getting inserted into the JSON request:
Wed Mar 12 16:45:51 EDT 2014:DEBUG:>> "{"merchid":"","accttype":"","account":"","\n]"