You are viewing limited content. For full access, please sign in.

Question

Question

insert read json in database

asked on February 6, 2024

Hello

I have successfully retrieve the values using http web request and read json.

Now I want for each read json value which have the same id to be inserted in 1 row in SQL Server.

Can anyone try to design a similar workflow and help me please? Thanks.

0 0

Replies

replied on February 6, 2024

I think this will work:

Do a "For Each Value" activity, listing just the "id" token from your "Read JSON" activity.  You don't need to list the other tokens in the "For Each Value" activity, because we just want the iteration value as it loops through it.

Within the "For Each Value" activity, include an "Insert Data" activity.  Insert the various tokens, selecting their index value based on the interation of the "For Each Value" activity.

As long as all of the tokens are getting the same number of records back from the web request and the "Read JSON" activity, this should work.

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.