Pentaho Data Integration : JSON input Step

JSON (JavaScript Object Notation) is a text based, light weight data inter change format.
This format enjoys a wide availability of implementations and is platform independent.

Stepwise illustration on the usage of Pentaho JSON step given below.

Step 1

Create sample transformation with JSON input step.

Step 2

Browse and add sample test file in JSON format.

Sample JSON Input data file :
Real time stock quotes in JSON format used as sample test input for demo purpose.

{"DAY_LOW":547.81,"BID":551.08,"OPEN":550.88,"52WK_LOW":385.1,"LAST_TRADE":551.08,"DAY_HIGH":557.29,"STOCK_NAME":"APPLE INC",
"RUN_DATE":"2014-01-22 12:10:04.000000000","VOLUME":11654341,"STOCK_SYMBOL":"AAPL","52WK_HIGH":575.14,"ASK":551.17},

{"DAY_LOW":1158.86,"BID":1162.3,"OPEN":1166.6,"52WK_LOW":735.79,"LAST_TRADE":1162.54,"DAY_HIGH":1167.89,"STOCK_NAME":"GOOGLE INC","RUN_DATE":"2014-01-22 12:10:04.000000000","VOLUME":1064205,"STOCK_SYMBOL":"GOOG","52WK_HIGH":1164.0,"ASK":1162.62},


"RUN_DATE":"2014-01-22 12:10:05.000000000","VOLUME":52050684,"STOCK_SYMBOL":"FB","52WK_HIGH":58.96,"ASK":57.27},
"RUN_DATE":"2014-01-22 12:10:05.000000000","VOLUME":8438596,"STOCK_SYMBOL":"YHOO","52WK_HIGH":41.72,"ASK":40.07},
"RUN_DATE":"2014-01-22 12:10:05.000000000","VOLUME":14150161,"STOCK_SYMBOL":"MSFT","52WK_HIGH":38.98,"ASK":36.08}

Step 3

Configure the field names and paths.
This can vary based requirements.

For example, individual field values can be retrieved using following paths.


All records can be retrieved by specifying "*" wild card in the path.
eg : $.stockdata.*

Step 4

Preview source data.

For Individual fields

For all records


Unknown said...

i have json file like this, where type is the column and content is the value of the column, ho i can transform.

"type": "compressed_part_number",
"content": "TSW13208GSRA"
"type": "part_id",
"content": "16313698"
"type": "manufacturer",
"content": "SAMTEC"
"type": "sentenceblock",
"content": "Easily mount this TSW-132-08-G-S-RA header connector from Samtec onto your PCB project."

Unknown said...

i have json file like this, where type is the column and content is the value of the column, so how i can transform?

Unknown said...

i have json file like this, where type is the column and content is the value of the column, so how i can transform?

Anonymous said...

The $.. structure is not working for me. I get a row with ALL of the data in each row. It would be as if all of the JSON response for stock data was written on each record. Any ideas on how to overcome that?

Anonymous said...

Nevermind it actually did work, but in the preview rows, it was very confusing. If anyone else runs into this, select the rows and put them in a csv file... it works!

Unknown said...

I am using the variable path as ($..X..Y..Z) , for i intend to pick values from path X/Y/Z , but instead I also get the values from all underlying paths where folder Z is present, such as (X/Y/1/Z), (X/Y/2/Z), (X/Y/3/B/Z).

What should I do to get just the desired value and not any extra value ?

ERP said...

ERPTREE Offering Oracle fusion HCM online training, Oracle Fusion SCM Online Training, Oracle fusion financials online
training, Oracle fusion hcm training, Oracle fusion scm training, Oracle fusion financials training,
Oracle fusion dba online training in Hyderabad, Bangalore,Gurgon, Noida, India, Dubai, UAE, USA, Kuwait, UK, Singapore, Saudi Arabia, Canada,
Delhi, Chennai, Kolkata, Pune, Mumbai, Ahmedabad.

Oracle fusion HCM Online Training

Oracle Fusion HCM Training

for ict 99 said...


Tanika Co Valda said...

Hi, Great.. Tutorial is just awesome..It is really helpful for a newbie like me.. I am a regular follower of your blog. Really very informative post you shared here. Kindly keep blogging. If anyone wants to become a Front end developer learn from Javascript Training in Chennai . or learn thru Javascript Training in Chennai. Nowadays JavaScript has tons of job opportunities on various vertical industry. JavaScript Training in Chennai

Mary Petter said...

Great Article Artificial Intelligence Projects

Project Center in Chennai

JavaScript Training in Chennai

JavaScript Training in Chennai

Unknown said...

instagram takipçi satın al
ucuz takipçi
takipçi satın al
instagram takipçi satın al
instagram takipçi satın al
balon perdeler
petek üstü perde
mutfak tül modelleri
kısa perde modelleri
fon perde modelleri
tül perde modelleri
yasaklı sitelere giriş
aşk kitapları
yabancı şarkılar
sigorta sorgula
word indir ücretsiz
tiktok jeton hilesi
rastgele görüntülü sohbet
fitness moves
gym workouts

Unknown said...

Unknown said...


Unknown said...

ucuz takipçi
ucuz takipçi
tiktok izlenme satın al
binance güvenilir mi
okex güvenilir mi
paribu güvenilir mi
bitexen güvenilir mi
coinbase güvenilir mi
instagram takipçi satın al

Home Decor said...

Türkiye'nin en güvenli ve en hızlı torrent oyun sitesi olan herkes davetlidir.

Unknown said...

Ucuz, kaliteli ve organik sosyal medya hizmetleri satın almak için Ravje Medyayı tercih edebilir ve sosyal medya hesaplarını hızla büyütebilirsin. Ravje Medya ile sosyal medya hesaplarını organik ve gerçek kişiler ile geliştirebilir, kişisel ya da ticari hesapların için Ravje Medyayı tercih edebilirsin. Ravje Medya internet sitesine giriş yapmak için hemen tıkla:

İnstagram takipçi satın almak için Ravje Medya hizmetlerini tercih edebilir, güvenilir ve gerçek takipçilere Ravje Medya ile ulaşabilirsin. İnstagram takipçi satın almak artık Ravje Medya ile oldukça güvenilir. Hemen instagram takipçi satın almak için Ravje Medyanın ilgili sayfasını ziyaret et: instagram takipçi satın al

Tiktok takipçi satın al istiyorsan tercihini Ravje Medya yap! Ravje Medya uzman kadrosu ve profesyonel ekibi ile sizlere Tiktok takipçi satın alma hizmetide sunmaktadır. Tiktok takipçi satın almak için hemen tıkla: tiktok takipçi satın al

İnstagram beğeni satın almak için Ravje medya instagram beğeni satın al sayfasına giriş yap, hızlı ve kaliteli instagram beğeni satın al: instagram beğeni satın al

Youtube izlenme satın al sayfası ile hemen youtube izlenme satın al! Ravje medya kalitesi ile hemen youtube izlenme satın almak için tıklayın: youtube izlenme satın al

Twitter takipçi satın almak istiyorsan Ravje medya twitter takipçi satın al sayfasına tıkla, Ravje medya güvencesi ile organik twitter takipçi satın al: twitter takipçi satın al


Great, I have read all the points and suggestions here, very deeply .. I hope you will be writing the 2nd part of this blog very soon.. Turkey visa from Egypt. The Citizens of Egypt can easily visit from Egypt to Turkey. No need to meet with any embassy especially to get his Turkish e Visa electronically. It is a time saving activity .The application process is 100 percent online.

sfdkl said...

Just wanted to congratulate you for such an amazing contents,So happy to read your post!
dachshund puppies for sale
dachshund puppy for sale
dachshunds puppies for sale
dachshund puppies sale
dachshund for sale

dachshund puppies for sale near me
dachshunds for sale
mini dachshund puppy for sale
mini dachshund puppies for sale

sfdkl said...

Please guys let give this blog FIVE STAR Rating
dapple dachshund puppies for sale
miniature long haired dachshund puppies for sale
miniature long haired dachshund for sale
dachshund puppies for sale under $500

long haired dachshund puppies for sale
teacup chihuahua for sale
chihuahua puppies for sale
chihuahua for sale

Post a Comment