add_source_step
Adds or replaces a table's data-source step using a specified connector and parameters, while preserving downstream steps.
Instructions
Seed or replace a table's data-source step with a generated connector expression (downstream steps preserved). connector = sql | oracle | mysql | postgresql | db2 | web | odata | excel | csv | json | xml | pdf | html | analysisservices | odbc | oledb | folder | sharepoint | azureblob | azuretable | datalake | deltalake | cdm. params is comma-separated key=value pairs; required keys per connector: sql/oracle/mysql/postgresql/db2 -> server, database (optional query); analysisservices -> server, database (optional query = MDX/DAX); web -> url (optional relativePath, query as a raw M record e.g. [#"$top"="10"], headers as a raw M record, content for a POST binary, apiKeyName, manualStatusHandling e.g. 404,500); odata -> url (optional filter/select/top/orderby folded into $filter/$select/$top/$orderby); excel/pdf -> path; csv -> path (optional delimiter, columns); json/xml/html -> path OR url; odbc -> connectionString or dsn (optional query); oledb -> connectionString (optional query); folder -> path; sharepoint -> url; azureblob/azuretable -> account; datalake/deltalake/cdm -> url. Static base URL + relativePath/query is the refresh-safe web pattern.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| params | Yes | connector parameters as key=value, comma-separated (see description) | |
| connector | Yes | the connector kind (see description for the full list) | |
| sessionId | Yes | ||
| partitionName | No | partition name (optional; defaults to the first partition) |