I have a Copy Data activity in a Microsoft Fabric Data Factory pipeline.
The activity connects to a REST API and writes the resultant JSON file to a folder in a lakehouse. I would like the destination filename to contain some data from the REST API response. For example, if the REST API response contains a date or a customer name, I'd like to include that date or name in the output filename. My problem is that there doesn't appear to be any way to reference the response object within the Copy Data activity. In the Destination tab, if I use the Expression Builder to create a dynamic file name, it does not recognize $.customer_name or anything else.
Is there any way to grab or interrogate attributes of the JSON object before it is written out to the lakehouse?
EDIT: I have also subsequently noticed that there is no way to reference the contents of the JSON document in a subsequent activity in the pipeline.
