Try this: {stores}
Data Flow Script: field name causing error
My Source is the following JSON:
{
"stores": "test"
}
My Data Flow Script is the following:
source(output(
stores as string
),
allowSchemaDrift: true,
validateSchema: false,
ignoreNoFilesFound: false,
documentForm: 'singleDocument') ~> source1
When I run the data preview, I get the following error:
Error:
DF-DSL-001 DSL stream has parsing errors
Line 2 Position 2: no viable alternative at input 'output(\n\t\tstores' - RunId: 2f5e92eb-1d00-4b1e-ab1e-d56822f3d8aa
If I change the JSON field name to "store", and modify the data flow script accordingly, there is no issue.
I assume stores is a reserved word? I have tried escaping with backticks or single/double quotes but these are not accepted as valid scripts.
2 answers
Sort by: Most helpful
-
MarkKromer-MSFT 5,211 Reputation points Microsoft Employee
2021-07-27T07:00:47.7+00:00 -
Mark Kromer MSFT 1,146 Reputation points
2021-07-27T23:36:48.947+00:00 Sounds like a possible bug. Would you mind filing a support ticket from the Azure portal?