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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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