Forum Discussion

GanguP's avatar
GanguP
New Contributor III
2 years ago
Solved

Extract or Flatten JSON Array data as columns

Need help in to pulling data from the below JSON and also from the Array (Tags) below.   I also went through the documentation but unable to get to the solution.     "entity": { "totalRecords"...
  • Aleksandar_A's avatar
    Aleksandar_A
    3 years ago

    Hi @arvindnsn,

    You can try to filter out documents that have “error” keys, and later on to split them using JSON Splitter Snap.

    $result.filter(x => x.hasPath("error"))

    Let me know if this helps you.

    BR,
    Aleksandar.

koryknick's avatar
koryknick
Employee
2 years ago

GanguP - rather than specify the individual columns to retain, you can select the "Include scalar parents" checkbox.  As long as the element is a primitive datatype (i.e. not array or object), it will automatically let it pass through.

GanguP's avatar
GanguP
New Contributor III
2 years ago

 Thank you so much @Kory  .  Appreciate your quick response