Forum Discussion

1_'s avatar
1_
Occasional Contributor
12 years ago

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]"
  • SiKing's avatar
    SiKing
    Community Expert
    This is only a guess! Try it without the quotes.