Forum Discussion

Gangadhar's avatar
Gangadhar
Occasional Contributor
9 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?
Gangadhar's avatar
Gangadhar
Occasional Contributor
9 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

nmrao's avatar
nmrao
Community Hero
9 years ago
Have tried hitting the request? What do you see in the raw request?
  • Gangadhar's avatar
    Gangadhar
    Occasional Contributor
    9 years ago

    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

    • Gangadhar's avatar
      Gangadhar
      Occasional Contributor
      9 years ago

      Find below raw attachment.

      • Gangadhar's avatar
        Gangadhar
        Occasional Contributor
        9 years ago

        Hi Rao,

                 Please try to provide the solution. I need it. Please find the raw request attachment. 

         

        Thanks & Regards,

        Gangadhar Badagi