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)
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?
Discussion posts and replies are publicly visible
One thing to confirm - did you actually use 0 as the index or were you just giving an example? Because Appian uses 1 indexing, so you should always start with 1 to get the first item. If that's not your issue, could you post a screenshot of your write to data store entity node?
yes, actually I used 2
Ok can you post a screenshot of the write to data store entity node? Also can you post the full error message you're receiving?
Ok,
So I debuged more and write to db node appears to work with a plain row definition like this:
={ {
entity: cons!RS_TestConst,
data: {id: NULL,name: "today_entry" , numb: 100}
}
Then I focused on the "call integration" node to save into a process variable - see screenshots.
I made a process variable of type "orders" - this is a data type with all the fields. then tried to
save body.orders[1] into it --- process variable single value, and also process variable multiple values (that is what you see in the screenshot
But in general if my integration is working and returns a bunch of "rows" in JSON format - what is the "best" approach to save those into a table?
Is it possible that the result from the integration is returning all the JSON as text? There's an option in your integration that converts the JSON response to a dictionary, but if you don't choose that it will return the body as one big text string (and you can't index into that text string).
Assuming that you do choose that option, you certainly should be able to save the orders as a process variable of type "Orders". Can you show your full output from the integration? Then we can see if the index works for the given response.
Yes - the integration was setup like that "Convert JSON to Appian Value" - but was not working,
However, when I edited from within the node properties it took effect and now I can iterate and save into process variable