I need to handle some complex state with Azure Data Factory (ADF). AFAIK, the only mechanic that Azure provide you with - is SetVariable
activity which accepts only single value.
What to do if I need something more complex? A JSON structure for instance
How can I perform the following steps:
- Read some state from SQL database
- Enrich the SQL-query results with ADF pipeline variables
- Pass the enriched result as JSON payload to ADF's
Webhook
activity - Accept
JSON
as response toWebhook
activity and store it into SQL database