JsonPath Array

• info 58414

  Hall of Fame

  Points: 3386

  More actions

  June 11, 2019 at 12:22 pm

  #3652264

  Hi,

  i read a JSON-File into a var.

  SELECT @json = BulkColumn FROM OPENROWSET(BULK 'C:\Tmp\MyJson.json', SINGLE_CLOB) AS j;

  The Json looks like this:

  {

  "d": {

  "results": [

  {

  "__metadata":

  {

  "id": "http://xxxx('900000856')",

  "uri": "http://xxxx('900000856')",

  "type": "businessPartner"

  },

  "businessPartnerNumber": "1111111111",

  "origin": ""

  },

  {

  "__metadata": {

  "id": "http://xxxx('1000002000')",

  "uri": "http://xxxx('1000002000')",

  "type": "Z_AZURE_SRV.businessPartner"

  },

  "businessPartnerNumber": "2222222222",

  "origin": "AL"

  }

  ]

  }

  }

  My Code returns NULL  . Can you tell me, what's wrong with my json.path?

  SELECT *

  FROM

  OPENJSON(@JSON)

  WITH

  (

  businessPartnerNumber VARCHAR(200) '$.results.businessPartnerNumber'

  ,origin VARCHAR(200) '$.results.origin'

  );

  Thanks

  Regards

  Nicole

   

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  June 12, 2019 at 1:10 pm

  #3652734

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.