<iframe src="https://www.googletagmanager.com/ns.html?id=GTM-M74D8PB" height="0" width="0" style="display:none;visibility:hidden">
Loading
Skip to NavigationSkip to Main Content
0D54z0000A9m3B8CQIOkta Identity EngineWorkflowsAnswered2024-06-28T20:28:40.000Z2024-06-19T08:39:49.000Z2024-06-28T20:28:40.000Z

ChrisL.07064 (Customer) asked a question.

Workflows - Parse JSON and write into table

Hi, we created an endpoint within workflows where a JSON gets send in the following format:

 

{

  "identities": [{

       "BusinessKey": "test",

      "FirstName": "test",

"LastName": "test",

"Status": "test",

"EmployeeID": test,

"Category": "test",

"ValidFrom": "01.01.2999",

"ValidTo": "",

"CostCenter": test,

"ID_Card_number": test,

"Email": "test",

"Context_BusinessKey": test

    },

    {

"BusinessKey": "test",

      "FirstName": "test",

"LastName": "test",

"Status": "test",

"EmployeeID": test,

"Category": "test",

"ValidFrom": "01.01.2999,

"ValidTo": "",

"CostCenter": test,

"ID_Card_number": test,

"Email": "test",

"Context_BusinessKey": test

  ]

}

 

How do i accomplish such a workflow so that i iterate over all of the values from the object "identities" and write them one by one into a table?


  • TimL.58332 (Workflows)

    @ChrisL.07064 (Customer)​  -- Would have been easier if your example was valid JSON. But after fixing it I created and attached an example flopack that you can import that will demonstrate how to process inputs displayed above.

     

     

    Selected as Best
  • TimL.58332 (Workflows)

    @ChrisL.07064 (Customer)​  -- Would have been easier if your example was valid JSON. But after fixing it I created and attached an example flopack that you can import that will demonstrate how to process inputs displayed above.

     

     

    Selected as Best
This question is closed.
Loading
Workflows - Parse JSON and write into table