Since with the introduction of Web Request / Iterate Web Request we are now in the business of dealing with external RESTful APIs, for our users it will be necessary at some point to parse incoming JSONs as well as generate JSONs too. We will be introducing dedicated actions for parsing JSON in vers…

Hi @dgudkov - I'm looking at the JSON file that would be a typical response back in a flat example: Something like this: Sample from Magento GET Inventory by SKU {"item_id":953294,"product_id":690692,"stock_id":1,"qty":99,"is_in_stock":true,"is_qty_decimal":false,"show_default_notification_mess…

[image] adambeltz: Sample from Magento GET Inventory by SKU {“item_id”:953294,“product_id”:690692,“stock_id”:1,“qty”:99,“is_in_stock”:true,“is_qty_decimal”:false,“show_default_notification_message”:false,“use_config_min_qty”:true,“min_qty”:10,“use_config_min_sale_qty”:1,“min_sale_qty”:1,“use_co…

So far it's really good. I can extract metadata and data from IBM Planning Analytics/TM1 very useful.

Looking for guidance on the nested JSON (until introduction of the Parse action) - Is this something already available to work with?

To some extent. There are 3 options available how to extract data from nested JSONs until introduction of the Parse action (which is a big-big priority for us): Usual transformations and text functions that existed before 4.0. Function jsonvalue() described above - one function would be necessary …

***** moved from Beta lounge to General Q&A

Tip to find the jsonpath quickly: JSON Path Finder JSON Path Finder

Hi Dmitry, What's the JSON path expression to filter only the objectId for de 2 items with objectType = Gebouweenheid in this array ? How can I apply a filter in some way I always get errors? I have tried the following but it throws an error. Maybe somethting with the quotes ? jsonvalue( [Respo…

Hi Nikolaas, wait for the "Parse JSON" action in v4.1. While JSONPath expressions can be quite powerful, we will be recommending using "Parse JSON" and apply regular EasyMorph actions.

Hi I understand that but I would like to use it now.... When I do the following it works when I test it in the online tool (without the surrounding quotes) https://jsonpath.curiousconcept.com/ In easyMorph I get an error. What could be the reason? 'adresMatches[0].adresseerbareObjecten[?(@.obje…

EasyMorph Community - Data preparation professionals and enthusiasts

Parsing JSON/XML from web responses

To learn more about EasyMorph visit easymorph.com.