Power Query: external mashups
Reading, writing, and refreshing Power Query query sets assembled outside the product. Operations on this page: 3.
Reading, writing, and refreshing Power Query query sets assembled outside the product. Terms are in the glossary.
Operations on this page — 3
read_foreign_mashup
Section titled “read_foreign_mashup”Request
| Field | TypeScript type | Req. |
|---|---|---|
| operation | “read_foreign_mashup” | yes |
subsetId |
string | yes |
Response on success · read_foreign_mashup
| Field | TypeScript type | Req. |
|---|---|---|
| operation | “read_foreign_mashup” | yes |
| projection | ContractForeignMashupProjection | yes |
Minimal JSON template
{ "operation": "read_foreign_mashup", "subsetId": "<subsetId>"}refresh_foreign_mashup_query
Section titled “refresh_foreign_mashup_query”Request
| Field | TypeScript type | Req. | What it is |
|---|---|---|---|
| operation | “refresh_foreign_mashup_query” | yes | |
expectedRevision |
number | yes | |
subsetId |
string | yes | |
queryIdentity |
string | yes | |
| generation | number | yes | The caller’s generation, returned unchanged: a stale response is dropped deterministically. |
| cancel | boolean | no | Cancellation only advances the generation fence — it computes and changes nothing. |
Response on success · refresh_foreign_mashup_query
| Field | TypeScript type | Req. |
|---|---|---|
| operation | “refresh_foreign_mashup_query” | yes |
| outcome | ContractForeignMashupRefreshResult | yes |
Minimal JSON template
{ "operation": "refresh_foreign_mashup_query", "expectedRevision": 0, "subsetId": "<subsetId>", "queryIdentity": "<queryIdentity>", "generation": 0}write_foreign_mashup
Section titled “write_foreign_mashup”Request
| Field | TypeScript type | Req. |
|---|---|---|
| operation | “write_foreign_mashup” | yes |
expectedRevision |
number | yes |
subsetId |
string | yes |
readOnly |
boolean | no |
| edits | ContractMashupWriteEdit[] | yes |
Response on success · write_foreign_mashup
| Field | TypeScript type | Req. |
|---|---|---|
| operation | “write_foreign_mashup” | yes |
| outcome | ContractMashupWriteResult | yes |
Minimal JSON template
{ "operation": "write_foreign_mashup", "expectedRevision": 0, "subsetId": "<subsetId>", "edits": []}