Reading and Parsing JSON Response

Hi Team,

My application is relying on an integration with Databricks to retrieve data and process the data in my application.

I used the activity called 'Read JSON' to extract the data required to a process variable. However, I will still need to break down the data further as the data is being stored as an array in the process variable.

Is there a way or an activity to use to transform the data stored in the process variable before finally saving it into data entity?

One observation that I think might be a limitation is that in the Read JSON Activity, after providing the sample JSON, in the mapping of the schema configuration, the list of schema available for mapping is not the columns of the table that I am looking for.

I assume that this is the default way that AgilePoint parse the JSON.

Reading and Parsing JSON Response

Comments

Didn't find what you were looking for?