Skip to main content
Nintex Community Menu Bar

Extract data from Json response

  • August 17, 2017
  • 1 reply
  • 47 views

Forum|alt.badge.img+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

Forum|alt.badge.img+14
  • Scholar
  • August 17, 2017

following regular expression should work

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

206814_pastedImage_1.png