Forum Discussion

Gangadhar's avatar
Gangadhar
Occasional Contributor
8 years ago

How to convert excel data to json?How to get data as Json from Datasource?

How to call REST Api for bulk data which is present in Excel and convertion of that data to json?

9 Replies

Sort By
  • nmrao's avatar
    nmrao
    Champion Level 3
    8 years ago
    It is difficult to comment without seeing the data.

    Please post more details, use screen shots or short video if required to explain the issue.
    • Gangadhar's avatar
      Gangadhar
      Occasional Contributor
      8 years ago

      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

      • Gangadhar's avatar
        Gangadhar
        Occasional Contributor
        8 years ago

         

        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