Dynamics 365 F&O/AX
Dynamics FO / AX
Organizer:
- Organized by
-
-
JSON Schema for Data Events
-
JSON Schema for Data Events
Does anyone have an example of a JSON Schema for Data Events in Finance and Operations? I am looking specifically for DataEvent_SalesTableWBiEntity_Update specifically but I can use any example to create a schema.
-
1 Reply
-
I was able to find a reasonably good way to translate the monster JSON dataset sent by the event into a manageable dataset for use in Logic Apps or Power Automate. I accomplished this using the Transform JSON to JSON action in logic apps and using the following DotLiquid template to do the transformation. This will pluck the resulting data table record from the event and return a JSON object with all of the columns in the table. The template is suitable for any table since it Dynamically gets the column names.
{
{%- assign inputparameters = content.InputParameters -%}
{%- for target in inputparameters -%}
{%- if target.Key == “Target” -%}
{%- for attribute in target.Value.Attributes -%}
{%- if forloop.Last == true -%}
“{{attribute.Key}}”:”{{attribute.Value}}”
{%- else -%}
“{{attribute.Key}}”:”{{attribute.Value}}”,
{%- endif -%}
{%- endfor -%}
{%- endif -%}
{%- endfor -%}
}
Log in to reply.
