How to extract values from a JSON structure using Pentaho - Video #4

This video will show how you can use data from a "Table input"-transformation to generate multiple "REST Client"-calls in Pentaho.
It also shows how to extract certain values fra the JSON structure and store that in a MySQL table

[@madhusogam5823]

You explain it so well.. thanks for sharing this. :)

[@MrBamshy]

How about situations where not all leaf has a value i.e. key and value is optional in some nodes. Example: 2 fields - $..variables[*].values[*].id and $..variables[*].values[*].text, where the latter is optional in some objects. How would you do this? Pentao throws error of different valuecount

[@nikitarankhamb2075]

How to use selenium automation in user define Java class plug-in

[@ericjonas6044]

Seriously this is a good tutorial :) keep it up. By the way, Let's say I have a excel file with 20 columns of data. 1 of the column is brand name I want to check the db whether my brand name exists, if exists do nothing, if not create a new brand. How can I do if-else for such case in pentaho data integration. So for my 20 columns of data, I need to do if-else check in db for around 3 - 4 times (brand, model, etc) Lastly for the image column, I need to call a REST api to push jpeg files to Amazon S3. Is it possible to do all in 1 process? Or should I break it apart? Wonder you can create a tutorial something like that too :) Thanks :)

[@henrikdahl4129]

Hi Erik Tnx for your comment. Let me get back to you on the tutorial-request.

[@mukkk]

Hi Henrik! I would like to ask you for help to use API rest step, with authentication and body. Do you have a case or may be I can send you the one I have?

[@sandeepj7414]

How do I upload mysql Table to facebook page using pentaho PDI ver 7. Can you provide a transformation mapping

[@Ricardo-mk2et]

Why there is no more videos?