Pentaho

 View Only

  • 1.  Is it possible to invoke REST API from Penatho?

    Posted 03-15-2022 01:16
    Hi Team,

    I have a requirement like to invoke API from Penatho directly.

    Thanks,
    Ratnam.

    ------------------------------
    EN Ratnam
    IT Support Manager
    Mindtree
    ------------------------------


  • 2.  RE: Is it possible to invoke REST API from Penatho?

    Posted 03-15-2022 07:44
    Hello,

    Yes it is possible. The way I have mine working is to us a generate rows step containing the URL, Authorization, accept and content type strings, I then feed those to the rest step, that returns a JSON response where I use a JSON step to parse the data into separate fields that I can format according to my needs. Works very well. Only gotcha for me what the pagination for my specific API only returns 500 lines at a time so I needed to change the URL in the generate rows field to add an offset to each call and just up the offset 500 for each API call.

    ------------------------------
    Brandon Patterson
    ------------------------------

    Original Message


  • 3.  RE: Is it possible to invoke REST API from Penatho?

    Posted 03-22-2022 06:45
    Thank you Brandon for the prompt reply. Let me test the same and come back to you with the results.

    ------------------------------
    EN Ratnam
    IT Support Manager
    Mindtree
    ------------------------------

    Original Message


Related Content