Forum Discussion

jmillsjmills's avatar
jmillsjmills
Icon for Helper III rankHelper III
4 years ago
Solved

Parsing JSON String within Custom Function

Hi,   I'm trying to parse a JSON string that currently sits in a column (shown in the screenshot). I've tried either with the record just as a text string ([Column1Copy]), or also with the JSON alr...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    4 years ago

    Hi jmillsjmills 

     

    Your ManipulationQuery is expecting the JSON as a Record, but it's receiving text.  So try wrapping the JSON text in Json.Document() before passing it to the function

    ManipulationQuery(Json.Document([JsonText]))

     

    Regards

     

    Phil

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
4 years ago

Hi jmillsjmills 

 

Your ManipulationQuery is expecting the JSON as a Record, but it's receiving text.  So try wrapping the JSON text in Json.Document() before passing it to the function

ManipulationQuery(Json.Document([JsonText]))

 

Regards

 

Phil

jmillsjmills's avatar
jmillsjmills
Icon for Helper III rankHelper III
4 years ago

This is perfect Philip! Thanks so much. Exactly what I needed