Extract data from Json response

  • 17 August 2017
  • 1 reply
  • 20 views

Badge +1

How can we retrieve specific data from the Json response ?

I want to retrieve  the "ProjectId" data (dddd-dddd-3c970eb9a9cb) from the below mentioned web request response .

Reaponse : {"odata.metadata":"https://xxx/xx/_api/ProjectData/$metadata#Projects","value":[{"ProjectId":"dddd-dddd-3c970eb9a9cb","EnterpriseProjectTypeDescription":"For when you want more control over the project , .....


1 reply

Userlevel 5
Badge +14

following regular expression should work

(?<="ProjectId":")[dw-]+(?=",)

206814_pastedImage_1.png

Reply