Passing dataset into Rest API using Azure data factory

Question

Passing dataset into Rest API using Azure data factory

Manikant Mahovia 41

Hi Everyone,

Is anyone know, how to pass the SQL database table dataset into rest API using Azure data factory.

I know the extracting data from rest API but want to pass the dataset into rest api.

Regards,

Manikant

HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator

2021-01-13T01:00:32.503+00:00

Hello @Manikant Mahovia ,
Thanks for the ask and using the forum .
Just trying understand that ask better , what is the use case where you want to pass a SQL table ? Is the intend to pass a JSON to an API with POST ?

Please do add more details , that will help us to guide you to a solution .

Thanks
Himanshu
Manikant Mahovia 41 Reputation points

2021-01-13T10:25:49.77+00:00

Hi Himanshu,

Yes, the case: I have 1000 rows in SQL table and want to move all this data a Json to an API with post method.

Using web activity passing dataset to Post API.

Source : SQL table
Target : Post API

Manikant

Accepted answer

0 additional answers

Your answer

HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator

2021-01-13T01:00:32.503+00:00

Hello @Manikant Mahovia ,
Thanks for the ask and using the forum .
Just trying understand that ask better , what is the use case where you want to pass a SQL table ? Is the intend to pass a JSON to an API with POST ?

Please do add more details , that will help us to guide you to a solution .

Thanks
Himanshu
Manikant Mahovia 41 Reputation points

2021-01-13T10:25:49.77+00:00

Hi Himanshu,

Yes, the case: I have 1000 rows in SQL table and want to move all this data a Json to an API with post method.

Using web activity passing dataset to Post API.

Source : SQL table
Target : Post API

Manikant

Answer 1

HimanshuSinha-msft 19,486 Microsoft Employee Moderator

Hello @Manikant Mahovia ,
Since you are using the SQL Server ( as the source ) , I think you can use the Lookup activity with a query option . SQL Server does support JSON in the SELECT statement , please read about that more here .
I think you can use the output of the lookup activity in the web activity .

@ hide (activity('Read Lookup Details').output.value)

Thanks Himanshu
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

HimanshuSinha-msft 19,486 Reputation points Microsoft Employee Moderator

2021-01-20T19:54:42.447+00:00

Hello @Manikant Mahovia ,
We have not heard back from you on this and was just following up if you have any further queries .
Thanks
Himanshu
Manikant Mahovia 41 Reputation points

2021-01-21T09:46:08.033+00:00
Hi Himanshu,

Thank you for your reply, and thank you so much.. your solution is working for me...

But If I select option "FirstRowOnly" in lookup activity the output is in correct json format... like below and working fine..

If I unchecked this option then result output of lookup activity like this..

"JSONVALUE": "{\"Type\":\"Private\",\"Private\":{\"FirstName\":\"AB\",\"LastName\":\"G.H.\"},\"Addresses\":[{\"StreetAddress\":\"string\",\"BuildingNumber\":\"1\",\"PostalCode\":\"18\"}]}"

Could you please help me on this.. What I am doing wrong.

Once again thank you for helping me.

Manikant
Manikant Mahovia 41 Reputation points

2021-01-21T12:35:14.007+00:00

Hi Himanshu,

The solution working fine... I was missing node value in @item().nodename

Thank you so much your help..

:)

Manikant

Share via

Passing dataset into Rest API using Azure data factory

0 additional answers

Your answer