Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Add Query Parameter Key-Value Table to Copy Data Activity REST Source

When using the Copy Data activity with a REST source, query string parameters must be manually concatenated into the Relative URL field. This is error-prone, hard to read, and does not scale when parameters are dynamic or vary in number.

Every comparable API tool (Postman, Power Automate HTTP connector, Logic Apps) provides a dedicated key-value parameters table that cleanly maps parameter names to values — including dynamic expressions.

 

Request: Add a "Query Parameters" section to the Copy Data activity REST source, where each row accepts a key and a dynamic or static value, and the tool assembles the query string automatically.

 

Current workaround: Pre-building the full query string in a Set Variable activity before the Copy, which adds unnecessary steps and complexity.

 

This would significantly improve usability for anyone calling paginated or filtered REST APIs in Fabric pipelines.

Status: New