Contributions
How to convert Datasource values(Data) to json array in Post request body?
Hi, Can you please advise how to take a list of values (e.g. in Excel) and then convert that to json array. I am getting values from excel in DataSource but I am unable to convert those values to json array in request body editor.. Please find the attachments. In request body I need json like below [ { "tcId":"ab_5", "tcName":"ab5", "tcDesc":"abc5", "tcType":"Other", "tcPriority":"Low" }] Can anybody help me to get json array as above in post request editor from Datasource ? Thanks & Regards, Gangadhar Badagi8 years agoPlace ReadyAPI QuestionsReadyAPI Questions2KViews0likes2CommentsRe: How to convert excel data to json?How to get data as Json from Datasource?
Can you please advise how to take a list of values (e.g. in Excel) and then convert that to json array. I am getting values from excel in DataSource but I am unable to convert those values to json in request body editor.. Please find the attachments. in request body I need json like below [ { "tcId":"ab1", "tcName":"ab1", "tcDesc":"abc1", "tcType":"Other", "tcPriority":"Low" }] Can anybody help me to get json body as above? Thanks & Regards, Gangadhar Badagi8 years agoPlace ReadyAPI QuestionsReadyAPI Questions5.9KViews0likes1CommentRe: How to convert excel data to json?How to get data as Json from Datasource?
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, Gangadhar8 years agoPlace ReadyAPI QuestionsReadyAPI Questions5.9KViews0likes4CommentsRe: How to convert excel data to json?How to get data as Json from Datasource?
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 advance8 years agoPlace ReadyAPI QuestionsReadyAPI Questions6KViews0likes6CommentsRe: How to convert excel data to json?How to get data as Json from Datasource?
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 Thanks8 years agoPlace ReadyAPI QuestionsReadyAPI Questions6KViews0likes7Comments