Can't get JSON field using tExtractJSONFields

Seven Stars

Can't get JSON field using tExtractJSONFields

This is my JSON:

 

{
  "access_token": "9dC-ifDuONHRRvpLI53oeBzx",
  "user": {
    "id": 1,
    "username": "try",
    "auth_key": "9dC-ifNH",
    "password_hash": "$2y$13$sD.N0myOtahcNls90FJ50kGN6t6",
    "password_reset_token": null,
    "email": "try@gmail.com",
    "status": 10,
    "created_at": 1505,
    "updated_at": 0
  }
}

 

I want to get the access_token field. I am trying this but it's not working:

 

1.JPG

Tags (2)

Accepted Solutions
Seven Stars

Re: Can't get JSON field using tExtractJSONFields

This is how I solved the problem:

 

1.JPG


All Replies
Seven Stars

Re: Can't get JSON field using tExtractJSONFields

Try changing JSONField from "body" to "string".

Twelve Stars

Re: Can't get JSON field using tExtractJSONFields

@dferre,please find the below way.

Untitled.pngUntitled.png

Manohar B
Twelve Stars

Re: Can't get JSON field using tExtractJSONFields

@dferre,check below one.Untitled.png

 

Manohar B
Seven Stars

Re: Can't get JSON field using tExtractJSONFields

This is how I solved the problem:

 

1.JPG