Reading Json response from clipboard

[mnaeem]

Hello Great Minds,
I am using PowerShell script and from PowerShell I am setting up a json content mentioned below in the clipboard, however when I try to fetch the content from the MS script it gives this

JsonContent

Code: Select all

{
  "errorCode": 0,
  "accountFileInfo": "D:\\Data\\automation\\clientAccount.csv"
}

MS Script to read the content from clipboard and parse the JSON

Code: Select all

Let>v_clipboardData=
GetClipBoard>v_clipboardData,0
JSONParse>%v_clipboardData%,$.errorCode,v_jsonErrorCode

I am getting 2 error prompts

• Line 6 : not appropriate

• Unexpected character in JSON data

Please advise how can parse the JSON content from the clipboard.

Thanks

[Marcus Tettmar]

Hi,

Remove the % characters around the clipboard variable in the JSONParse line. You can also remove Let and the format value.

Code: Select all

GetClipBoard>v_clipboardData
JSONParse>v_clipboardData,$.errorCode,v_jsonErrorCode