Forum Discussion
Copy data - Mapping section is Collection reference option
Hi, Trying to load data from a rest API using "Copy data". Got it working with pagination and everything, but can't access the real data as the "Collection reference" is missing in the gui...? ...
We're missing this option too.
We use this option a lot in pipelines in Azure Synapse. Currently we can't use Fabric because of the absence of this option.
Any updates on this? Or is there an Idea to vote for?
UPDATE
I found out that if you choose an 'External' sink first, the option will appear. You can set it at that time and change the sink afterwards to 'Workspace'. The setting 'Collection reference' is still set in the JSON definition.
Then just map like you normally would.