Hedrick - this was soooo helpful. You saved me hours of having to slug this out on my own. I always seem to be in the dark with Pentaho’s error reporting.

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

What's the added value of adding the URL in the 'Generate rows' block instead of directly into the REST transformation?

Hello sir

How to use results of one api to another api

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

Thank You. This video save me

Thanks a lot! Very Clear!

Hi! This is very helpful! Got some doubts: If I need to get the data with Body, this must be placen in the Rest? Also using Post, need to change the HTTP Method? Thanks!

Hi, your video helped me a lot but could you please explain how can I get the variables - omrade,ken,alder,civilstand,tid in the same JSON step as id, text, unit? or if the Variables had something like the below - "id":"FOLK1A", "unit":"antal", "variables":[ { "empid": "100", "empname":"John Doe"}, { "empid": "101", "empname":"Jack Doe"} ] Do I need to create a separate JSON Step but how will i get FOLK1A to have both emp ids 100 and 101?

Very clear and useful video - thanks Henrik.

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?

Hola estimado, vi tu video y tengo dudas al respecto prácticamente me arroja error con lo que explicas existe una configuración adicional??

Thanks for your tutorial!

Why there is no more videos?

Thanks! This helped me.

Can you help how to read json object stored MySQL table column and generate output ??

Very useful! Thanks a lot.

{"product": [ {"prdid":101,"prdname":"p1","price":200}, {"prdid":102,"prdname":"p2","price":250}, {"prdid":103,"prdname":"p3","price":300} ] } My problem is I need to update all price columns values is 500 in Kettel or Mysql as well ...and o/p should be at below format... ------ {"product": [ {"prdid":101,"prdname":"p1","price":500}, {"prdid":102,"prdname":"p2","price":500}, {"prdid":103,"prdname":"p3","price":500} ] } please help ,me solve this issues....

{"product": [ {"prdid":101,"prdname":"p1","price":200}, {"prdid":102,"prdname":"p2","price":250}, {"prdid":103,"prdname":"p3","price":300} ] } My problem is I need to update all price columns values is 500 in Kettel or Mysql as well ...and o/p should be at below format... ------ {"product": [ {"prdid":101,"prdname":"p1","price":500}, {"prdid":102,"prdname":"p2","price":500}, {"prdid":103,"prdname":"p3","price":500} ] } please help ,me solve this issues....

Hi Henrick, Can you post a video on how to transform MySQL Table and post it on Facebook webpage with Pentaho PDI version 7

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

Very helpful knowledge. Thanks for sharing Henrik.

Hi, how to use post method, I'm triyng pass one json generated on javascipt step (stringfy), but it doesn't work, throw mal formed

I did it like you but I have empty step with 'result'. Do you know why?

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

Thank you for sharing the information on Pentaho Services. Get more details on GrayMatter's Pentaho Services now @ pentaho.graymatter.co.in/pentaho-services

hrello its henrik d here

gr8 video

hey

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 :)

Very good.I am looking forward to the next video.

Very useful, keep sharing your knowledge....Thanks