Hi @60185333 ,
Welcome to Microsoft Q&A forum and thanks for reaching out here.
Yes, HTTP is not supported as source in Data flows and hence you won't be able to use it directly to flatten the complex JSON data from your HTTP Endpoint.
But as a workaround what you can do is to use the HTTP linked service to call the API endpoint and retrieve the JSON data to a blob storage as staging location using a copy activity, and then use the Data Flow activity next to copy activity and point data flow source to the HTTP response json file to transform the complex JSON data and extract the nested JSON values as needed.
Once you have the HTTP response data in storage blob, then in mapping data flow, you will have to use Flatten transformation to flatten the nested values.
Hope this helps.
Please don’t forget to
Accept Answer and
Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.