question

ewinkiser avatar image
0 Votes"
ewinkiser asked ewinkiser commented

Using a REST Call as a Source to an ADF Copy Activity not working...urgent please

Hello! @nasreen-akter @MartinJaffer-MSFT

Please see attached. I am trying to use a REST GET call as a Source in a COPY Activity; the Sink is a DB Table with only an EmployeeID column. When I run the REST CALL from Postman it sends back many employeeids, however when I use it in an ADF Copy Activity, only ONE employeeid is copied to the DB Table.

Any ideas? I have worked on this for hours....Thanks!!
Mike Kiser
96020-screenshot-2021-05-12-131457.jpg


azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered ewinkiser commented

Hi @ewinkiser,

Thanks for reaching out.

Looks like you are missing something in mapping section.

Mapping should be similar to below. Here is the related document: Hierarchical source to tabular sink

96477-image.png


If you are still blocked, please do share/attach the sample of your REST response with dummy data and also screenshot of your copy activity mapping for further assistance.

Hope this helps



Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.



image.png (64.5 KiB)
image.png (74.1 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ewinkiser,

Just checking in to see if the above suggestion was helpful. If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Thank you

1 Vote 1 ·

Hi @KranthiPakala-MSFT !

That worked perfectly!! Thank you very much! I didn't pay attention to that check box but I will know now and for the future....

Thanks again!
Mike Kiser

0 Votes 0 ·