Reading and Parsing JSON Response

Jordan Khaw

• 2026年09月30日 03:01

追蹤

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.

0

• 

  Jordan Khaw

  • 2026年09月30日 03:02

  Shared the sample JSON for your reference

  0

  評論操作 永久連結

請登入寫評論。