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
Eight Stars

Re: Can't get JSON field using tExtractJSONFields

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

Forteen Stars

Re: Can't get JSON field using tExtractJSONFields

@dferre,please find the below way.

Untitled.pngUntitled.png

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Forteen Stars

Re: Can't get JSON field using tExtractJSONFields

@dferre,check below one.Untitled.png

 

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Seven Stars

Re: Can't get JSON field using tExtractJSONFields

This is how I solved the problem:

 

1.JPG

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Talend API Designer – Technical Overview

Take a look at this technical overview video of Talend API Designer

Watch Now

Getting Started with APIs

Find out how to get started with APIs

Read