question

Clement-2081 avatar image
0 Votes"
Clement-2081 asked MarkKromer-2402 answered

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.

azure-data-factory
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MarkKromer-MSFT avatar image
0 Votes"
MarkKromer-MSFT answered Clement-2081 commented

Try this: {stores}

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi, I have tried your suggestion. This has not fixed the issue, and results in the same error.

It is accepted as a valid script in the UI, however when I re-open the script the curly brackets have been automatically removed.

Thanks,

0 Votes 0 ·
MarkKromer-2402 avatar image
0 Votes"
MarkKromer-2402 answered

Sounds like a possible bug. Would you mind filing a support ticket from the Azure portal?

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.