Complex JSON from a REST Api whith Dataflow

[Torin78D]

Hi.

I have a Rest API that retreives a complex json. In order to flatten that. Do i have to store de json in a file first? or can i flateen that json from the Rest API directly?

Do you know if is it an examle? (i found videos of flatten complex json from a json file, but not directly from a Rest API)

Thank you

[miguel · Accepted solution]

Please post this question in the Azure Data Factory forum using the link below:

https://techcommunity.microsoft.com/t5/azure-data-factory/bd-p/AzureDataFactory

The forum for Fabric Data Factory is specific to experiences only available through Fabric such as Dataflow Gen2.

[miguel]

could you share an example of the json file and how the final result table should look like for it?

in general, yes. You can use Dataflow for a scenario like this - what have you tried so far? Do you get any errors when you expand the columns or try to navigate through your json?

[Torin78D]

I get this error trying test connection

This api works properly in a copy_data task

[miguel]

Is this for Mapping Dataflows inside of Azure Data Factory?

[Torin78D]

yes