Unanswered

Parse JSON Output to SQL

(0) Share

Report

Posted on by crackerjack

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?

Screenshot 2021-04-17 at 5.02.09 PM.png

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

powercorner 477 on at

Like (0)

Report

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?

Greetz

Was this reply helpful? Yes No
crackerjack 6 on at

Like (0)

Report

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".

Was this reply helpful? Yes No
powercorner 477 on at

Like (0)

Report

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.
Like this:

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?

Was this reply helpful? Yes No
powercorner 477 on at

Like (0)

Report

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?

Was this reply helpful? Yes No