Get Free Trial

In "flat" mode its possible to JSON data value be an object?

Luis asked on July 28, 2021

Its possible to use a JSON object property (instead of a flat String) in a cell value?
Is there a way to use “country_name” as the cell value in the above example?

1 answer

Illia Yatsyshyn Illia Yatsyshyn Flexmonster July 29, 2021

Hello, Luis,
Thank you for posting on our forum.
Please note that object is not a supported data type for JSON data sources. You can find all the supported data types in our documentation: Data types in JSON | Flexmonster.
We would suggest splitting the “Country” field into two separate columns: “country_code” and “country_name”.
Please let us know if other questions arise.
Kind regards,

Please login or Register to Submit Answer