topic Re: Can't get JSON field using tExtractJSONFields in Talend Studio

Can't get JSON field using tExtractJSONFields

Anonymous — Sat, 16 Nov 2024 08:15:46 GMT

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:

Re: Can't get JSON field using tExtractJSONFields

Anonymous — Wed, 16 May 2018 13:06:01 GMT

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

Re: Can't get JSON field using tExtractJSONFields

manodwhb — Wed, 16 May 2018 13:07:20 GMT

@dferre,please find the below way.

Re: Can't get JSON field using tExtractJSONFields

manodwhb — Wed, 16 May 2018 13:53:56 GMT

@dferre,check below one.

Re: Can't get JSON field using tExtractJSONFields

Anonymous — Wed, 16 May 2018 15:03:06 GMT

This is how I solved the problem: