Proper data output for data integration between Azure Function (Http Trigger) and Azure Data Factory

Anonymous
2021-11-12T05:58:58.59+00:00

(Sorry, there is not much example in YouTube that discusses about Azure Function (Http Trigger) and Azure Data Factory data integration, so I am posting this question.)

I am trying to get a proper data output from Azure Function (Http Trigger) so that I could move data to Azure Data Factory.

From the example of solution file of Azure Function (Http Trigger), this is output that I got.

148677-image.png

When I connect to Azure Data Factory, what is expected input?
I don't think it is just one line of data or it is not URL, is it?

I am trying to get a tabular format of data into Azure Data Factory from Azure Function.
Where does the tabular format take place?
Is it from output of Azure Function or output from URL? I am so confused.

Do I have to possibly have an output like Json format in order to get a data in a tabular format?

What should be the data structure if I want to store a list of output like (UserID, FirstName, LastName) that have at least 1000 rows from Azure Function (Http Trigger) --> ADF?

Thanks you.

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
5,415 questions
0 comments No comments
{count} votes

Accepted answer
  1. Justin Doh 81 Reputation points
    2021-11-12T19:00:45.02+00:00

    @KingJava
    https://www.youtube.com/watch?v=ZKh2jNFbECA
    This video helped me.

    The return type of the Azure function has to be a valid JObject.
    https://learn.microsoft.com/en-us/azure/data-factory/control-flow-azure-function-activity

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.