Forum Discussion
See the thing is I have data in excel sheet and I can able to pull data from excel sheet but in my webservice request i have to send as json. So how can i convert DataSource data as Json. In Soap ui i am getting the values and in request i tried to get data(from getData()) but that is not in json format. Can you help me? Please find the attachment
Thanks
I am able fetch the data from Excel but I am unable to convert that to json which I need to send in request body as Json. Can anybody help me?
Please find the attachments and i request you to provide the solution.
Thanks in advance
- nmrao8 years agoChampion Level 3Have tried hitting the request? What do you see in the raw request?
- Gangadhar8 years agoOccasional Contributor
Ya I hit the request and it is giving internal server problem because the data which i got from Datasource is not in json format. So it is showing internal server problem. The value from datasource is coming as "ab_5ab5ab5OtherLow". Can you help me how to convert this value to json.
I need json like below
[{
"tcId":"ab_5",
"tcName":"ab5",
"tcDesc":"ab5",
"tcType":"Other",
"tcPriority":"Low"
}]
I am getting value from Datasource like "ab_5ab5ab5OtherLow". Please tell me how to convert this to my required json format.
Thanks & Regards,
Gangadhar
- Gangadhar8 years agoOccasional Contributor
Find below raw attachment.
Related Content
- 3 years agoprasath_2k
- 6 months agomacheshmeh