topic Re: Complex JSON from a REST Api whith Dataflow in Dataflow

Complex JSON from a REST Api whith Dataflow

Anonymous — Mon, 26 Aug 2024 07:05:32 GMT

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

Re: Complex JSON from a REST Api whith Dataflow

miguel — Mon, 26 Aug 2024 07:17:27 GMT

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?

Re: Complex JSON from a REST Api whith Dataflow

Anonymous — Mon, 26 Aug 2024 07:20:47 GMT

I get this error trying test connection

This api works properly in a copy_data task

Re: Complex JSON from a REST Api whith Dataflow

miguel — Mon, 26 Aug 2024 08:00:26 GMT

Is this for Mapping Dataflows inside of Azure Data Factory?

Re: Complex JSON from a REST Api whith Dataflow

Anonymous — Mon, 26 Aug 2024 08:04:58 GMT

yes

Re: Complex JSON from a REST Api whith Dataflow

miguel — Mon, 26 Aug 2024 08:09:47 GMT

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.