Forum Discussion

sobha353's avatar
sobha353
New Contributor
2 years ago
Solved

JSON Formatting - Mapping Key and Value

I have a pipeline which reads data from source in JSON format and below is the format of json data retrieved. I am looking to map the values and not getting the desired result since the data is in st...
  • ivicakoteski's avatar
    ivicakoteski
    2 years ago

    Hi sobha353 ,

    You can parse the string as JSON using the JSON.parse() function in the mapper snap.

     

    JSON.parse($dataDetails.data)

     

    Hence, you can easily map the data as desired.
    Hope this helps!

    BR.
    Ivica

ivicakoteski's avatar
ivicakoteski
New Contributor III
2 years ago
Copy LinkReport

Hi sobha353 ,

You can parse the string as JSON using the JSON.parse() function in the mapper snap.

 

JSON.parse($dataDetails.data)

 

Hence, you can easily map the data as desired.
Hope this helps!

BR.
Ivica