Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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:

 

0683p000009Lxg1.jpg

Labels (3)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

This is how I solved the problem:

 

0683p000009Lx9Y.jpg

View solution in original post

4 Replies
Anonymous
Not applicable
Author

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

manodwhb
Champion II
Champion II

@dferre,please find the below way.

0683p000009LxZp.png0683p000009Lxg6.png

manodwhb
Champion II
Champion II

@dferre,check below one.0683p000009LxOI.png

 

Anonymous
Not applicable
Author

This is how I solved the problem:

 

0683p000009Lx9Y.jpg