Azure-Player / azure.datafactory.devops

Azure DevOps Deployment Tasks for Azure Data Factory objects
MIT License
39 stars 21 forks source link

Error: "Invalid Json Primitive: https." when trying to apply environment configurations via CSV or JSON #46

Closed asherman-hsi closed 3 years ago

asherman-hsi commented 3 years ago

Hello,

I'm looking to leverage this tool for pipeline deployment of our Azure Data Factory, but I'm having trouble with the stage configuration step of the task. We've tried both a .csv and a .json configuration file, but in both cases we get the following error: "Invalid Json Primitive: https."

It appears that this happens when attempting to perform the replacement of the values to the actual json files. We've verified our formatting versus the examples provided in the documentation and aren't sure why this isn't working for us. Is there a way to get the debug output so we can determine which value is failing, specifically? Any guidance on known formatting issues, possibly a special character problem?

Thanks.

NowinskiK commented 3 years ago

Add "system.debug" = "true" to Variables. Debug mode should show more details.

asherman-hsi commented 3 years ago

Thanks Kamil,

To the pipeline variables or to the environment variables in the pipeline task?

Andrew Sherman DevOps Manager/Security Officer

From: Kamil Nowinski @.> Sent: Wednesday, May 5, 2021 3:19 PM To: SQLPlayer/azure.datafactory.devops @.> Cc: Andrew Sherman @.>; Author @.> Subject: Re: [SQLPlayer/azure.datafactory.devops] Error: "Invalid Json Primitive: https." when trying to apply environment configurations via CSV or JSON (#46)

External Email Warning!!

Add "system.debug" = "true" to Variables. Debug mode should show more details.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/SQLPlayer/azure.datafactory.devops/issues/46#issuecomment-833086673, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AO6STRJZN7TGWJVWWBGY77TTMG75JANCNFSM44F24RPQ. External Email Warning!!

This is an EXTERNAL EMAIL. If you are not expecting an attachment or do not recognize this sender, please do not click on links or open ATTACHMENTS!

asherman-hsi commented 3 years ago

I figured out the debug variable and now I am troubleshooting new errors. Thank you for that. I will post my resolution once I have found it but I now suspect formatting errors on my part.

Andrew Sherman DevOps Manager/Security Officer

From: Kamil Nowinski @.> Sent: Wednesday, May 5, 2021 3:19 PM To: SQLPlayer/azure.datafactory.devops @.> Cc: Andrew Sherman @.>; Author @.> Subject: Re: [SQLPlayer/azure.datafactory.devops] Error: "Invalid Json Primitive: https." when trying to apply environment configurations via CSV or JSON (#46)

External Email Warning!!

Add "system.debug" = "true" to Variables. Debug mode should show more details.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/SQLPlayer/azure.datafactory.devops/issues/46#issuecomment-833086673, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AO6STRJZN7TGWJVWWBGY77TTMG75JANCNFSM44F24RPQ. External Email Warning!!

This is an EXTERNAL EMAIL. If you are not expecting an attachment or do not recognize this sender, please do not click on links or open ATTACHMENTS!

NowinskiK commented 3 years ago

Great. I will close this issue now, however, please share your findings with us here.

asherman-hsi commented 3 years ago

Thanks.

Ultimately I had a formatting issue in my csv file, where I was not declaring the correct JSON element which created the mismatch. Specifically, I was missing the “default value” element. Hope this helps someone in the future.

Andrew Sherman DevOps Manager/Security Officer

From: Kamil Nowinski @.> Sent: Friday, May 7, 2021 6:04 AM To: SQLPlayer/azure.datafactory.devops @.> Cc: Andrew Sherman @.>; Author @.> Subject: Re: [SQLPlayer/azure.datafactory.devops] Error: "Invalid Json Primitive: https." when trying to apply environment configurations via CSV or JSON (#46)

External Email Warning!!

Great. I will close this issue now, however, please share your findings with us here.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/SQLPlayer/azure.datafactory.devops/issues/46#issuecomment-834363111, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AO6STRK6S4WTLJFDGWWB5YDTMPQMTANCNFSM44F24RPQ. External Email Warning!!

This is an EXTERNAL EMAIL. If you are not expecting an attachment or do not recognize this sender, please do not click on links or open ATTACHMENTS!

NowinskiK commented 3 years ago

Thanks @asherman-hsi !