call web integration to write to datastore
HI,
I am trying to create a process with 2 nodes: call an integration + write to db
The integration returns a Result.body - this variable is available in the next node....Example of body (json)
body (Dictionary)
- orders (List of Dictionary - 272 items)
- Dictionary
- orderNumber5105251(Number (Integer))
- operatingUnitId1030(Number (Integer))
- operatingUnitName"GEMSAM_OU_LNR_GEMS_LUNAR"(Text)
- contractAmount4600(Number (Integer))
- status"B"(Text)
- purchaseOrderNumber"1681345522"(Text)
- customerNumber"131441"(Text)
- customerName"WOODLAND MEMORIAL HOSPITAL"(Text)
- deleted0(Number (Integer))
- orderNumber5105251(Number (Integer))
- ....
-
- bookedDate11/1/2021 8:23 PM GMT+00:00(Date and Time)
- initDate11/1/2021 7:59 PM GMT+00:00(Date and Time)
- customerContractAmount4600(Number (Integer))
- bookedDate11/1/2021 8:23 PM GMT+00:00(Date and Time)
- Dictionary
- orderNumber5104156(Number (Integer))
- operatingUnitId1030(Number (Integer))
- customerNumber"5455"(Text)
- customerName"SOUND"(Text)
- .....
- orderNumber5104156(Number (Integer))
I tried to directly access the body.orders[0] for example at the write to db node but I am getting a "failed to index error"
I also tried to save the 1st item into a process variable in the call integration node, but I am getting the same error.
Any ideas?
I also followed the SpaceX sample with launches/rockets - which maps a rest api to a record store - I got this to work with my specific data type.
but these are not saved in any DB table....is there a way to save these into a db table afterwards?
