As you can see in the images, there are some values in the output of "Parse JSON". However, when I try to utilise these values, it is showing nothing in output. Any idea where I did wrong?
Which kind of output do you expect?
It looks like the insertion of the row succeeded and it gives you back an internalID.
What would be your goal here?
The insertion is successful but it is not getting the values from the parsed json.
For example, I would like to have the values from "RowKey", "Timestamp", "Details" and "Username".
Do you mean that the values "RowKey" ,"Timestamp" and so on are not written into the new inserted row?
Is the sql row empty? check your raw input of the sql insert action, what does it say?
If the sql row is empty, you should check your parser. maybe you could create variables for each parameter "RowKey", "Timestamp" and so on to see if the parser output is empty.
You can then insert the variables into your sql action.
if you want to get the data from the new row you could just use the "get-row" action and fill in the id from the "insert-row" action?
I just checked it out, you are right that the insert row should return the values in the output,
but it seems that your input is broken?
Check out the new Process Advisor community forum board!
Check out new user group experience and if you are a leader please create your group
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks