question

AdityaDuddalwar-4440 avatar image
0 Votes"
AdityaDuddalwar-4440 asked PRADEEPCHEEKATLA-MSFT commented

I am working on the project were we have the requirement to write the data from sql to Marketo through ADF we tried through web activity and rest Api, but we are struggling to get the response from marketo if any lead on this would be appreciated.

Hi
I am working on the project were we have the requirement to write the data from sql to Marketo through ADF we tried through web activity and rest Api, but we are struggling to get the response from marketo
if any lead on this would be appreciated.

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

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT commented

Hello @AdityaDuddalwar-4440,

Welcome to the Microsoft Q&A platform.

Currently, Marketo is only supported as the source and not supported as sink.

107417-image.png

For more details, refer to Copy data from Marketo using Azure Data Factory (Preview)

I would suggest you to provide feedback on the same:

https://feedback.azure.com/forums/270578-data-factory

All of the feedback you share in these forums will be monitored and reviewed by the Microsoft engineering teams responsible for building Azure.

Hope this helps. Do let us know if you any further queries.


  • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

  • Want a reminder to come back and check responses? Here is how to subscribe to a notification.


image.png (34.7 KiB)
· 3
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.

Hello @AdityaDuddalwar-4440,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·

Through Web Api we were able to read the response but we are not able to capture that response in sql table. any idea how to read foreach activity output to sql table

0 Votes 0 ·

Hello @AdityaDuddalwar-4440,

You cannot call Web API response directly to SQL.

The best way is to use copy activity and inside copy activity you can use source as the REST type dataset and sink as the SQL dataset.

0 Votes 0 ·