Data Factory how send JSON to REST with copy activity

Question

Data Factory how send JSON to REST with copy activity

spaz 41

Hi,

I want to send a complex JSON to a REST service, but the query creates the into row_to_json and I need remove this section before to send REST service.

Source:

Sink:

Mapping:

Thanks

KranthiPakala-MSFT 46,737 Reputation points Microsoft Employee Moderator

2022-04-06T06:26:15.467+00:00

Hello @spaz ,

Thanks for the question and using MS Q&A platform.

As understand the ask here is that you would like to know how to copy complex nested json array data to a REST endpoint. Please correct me if I'm not clear.

To better assist on this query, would you be able to share a sample JSON source file with dummy data. If so, please save the sample test file as .txt format and attach it to your response.

Thank you
KranthiPakala-MSFT 46,737 Reputation points Microsoft Employee Moderator

2022-04-07T21:51:10.8+00:00

Hello @spaz ,

Just checking to see if you have got a chance to see my previous comment? If so, kindly share the details requested for further assistance on this request. Also please confirm what is your source?
spaz 41 Reputation points

2022-04-12T03:50:58.94+00:00

Hi,

The source is a postgreSQL database, so I read the table and then apply a query to transform the table in a complex JSON and finally send to the REST service.

The file attached have info demo from the database.

192163-source3-data-preview.txt

Your answer

KranthiPakala-MSFT 46,737 Reputation points Microsoft Employee Moderator

2022-04-06T06:26:15.467+00:00

Hello @spaz ,

Thanks for the question and using MS Q&A platform.

As understand the ask here is that you would like to know how to copy complex nested json array data to a REST endpoint. Please correct me if I'm not clear.

To better assist on this query, would you be able to share a sample JSON source file with dummy data. If so, please save the sample test file as .txt format and attach it to your response.

Thank you
KranthiPakala-MSFT 46,737 Reputation points Microsoft Employee Moderator

2022-04-07T21:51:10.8+00:00

Hello @spaz ,

Just checking to see if you have got a chance to see my previous comment? If so, kindly share the details requested for further assistance on this request. Also please confirm what is your source?
spaz 41 Reputation points

2022-04-12T03:50:58.94+00:00

Hi,

The source is a postgreSQL database, so I read the table and then apply a query to transform the table in a complex JSON and finally send to the REST service.

The file attached have info demo from the database.

192163-source3-data-preview.txt

Share via

Data Factory how send JSON to REST with copy activity

Your answer