Hello,
I have created an API call with a .json file, however, I am struggling to process these attributes (after having used JSON Flattener), I think it should be easy but I cannot get it.
Attached the image, I would like to have the list of attribute that appears on the right side as a proper table in which each row means a different element.
Could anyone please help with this?
Thank you very much
Hi @claraosuna, a possible way is to expose the list members ("array{}.date", "array{}.id", "array{}.incr", .. etc.) with the AttributeExposer, and then use the ListExploder to transform the feature into record features for each element in the list.
In the JSONFlattener, make sure you manually expose the array{} list attribute, then use the ListExploder to create one feature per list element.
If necessary, you can also add an AttributeExposer for the list element attributes.
Hello @takashi and @david_r,
thank you very much for your response, I truly appreciate them.
I am trying to follow the workflow but I must be doing something wrong since I don't get anything successful, I attach the file
It is the first time that I use both tools so I am not quite sure how they work.
Thank you very much
Try removing the double quotes in the AttributeExposer.
It worked!!
Thank you very much.