File with Multiple JSON doc's - How to Merge them?

[KBD]

Hello:

I am working with files that contain multiple JSON doc's.

The files look something like this:

{"@odata.context":"https://xxxxdev.yyyy.us/contentapi/Facilities/$metadata#Facilities","value":[{"Fac_Id":247246,.........
{"@odata.context":"https://xxxxdev.yyyy.us/contentapi/Facilities/$metadata#Facilities","value":[]}

Each @odata  is return from a REST call.  There can be several until the empty one , the final one.

I need to combine the JSON docs.  Create one JSON object which will be processed futher. 

In a data flow I created a Source on top of a JSON dataset and set Document form to Document per line.

This read two records in the file 

Value in the first row contains the data I am interested in and in the second row value is empty.

Good.

How do I concatinate the two values to create one JSON object?

What transformations do I use?

Am I approaching this correctly?

Best Regards

KBD

[v-venuppu]

Hi @KBD ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @lbendlin for the prompt response.

You are reading multiple JSON documents (one per line), each with a value array.
Use Document per line in your JSON source to load them.Then apply a Flatten transformation on the value column to extract all items.This will combine all records from each JSON's value array into one dataset.Empty value arrays (like the last line) will be skipped automatically.

Thank you.

[lbendlin]

A standard "expand column"  should suffice.

please provide valid JSON responses for both scenarios.