You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@hop.apache.org by David McNeill <da...@mcpond.co.nz> on 2024/03/07 04:35:38 UTC
Pointers for.... basic web service API call
Thanks in advance to experienced Hop users.
I'm trying to query a normal, well behaved API web service
https://static.helpjuice.com/helpjuice_production/uploads/upload/image/6005/direct/1663303044502-Infusion%20Public%20API%20Version%201.pdf
https://app.infusionbusinesssoftware.com/api/swagger-ui/index.html
Is the Rest Client transform the correct input to use?
https://hop.apache.org/manual/latest/pipeline/transforms/rest.html
This particular web service takes two GET query parameters, not user/pass
but session id and licence id, which I have. How do I configure these, or
how do I create a custom transform that can correctly ask for these?
When I try the REST client, from the Hop fat client, it doesn't actually do
anything, it doesn't make an http query. I've set the URL, get method is
GET, press play, launch.
It tried changing the URL to just http://localhost:9090, and running a
netcat nc -l 9090 listener, to see if it made any request at all. Nope,
it's mute. Nothing going out. Log snip below.
Ideally, I'd like to create an elegant connection definition that serves
the web service above. Can anyone point to the correct type of doc on how
to build one of these?
Thanks,
David.
2024/03/07 17:27:57 - InFusion.0 - Starting allocation of buffers & new
threads...
2024/03/07 17:27:57 - InFusion.0 - Transform info: nrinput=0 nroutput=0
2024/03/07 17:27:57 - InFusion.0 - Finished dispatching
2024/03/07 17:27:57 - infusion-staff - Pipeline has allocated a new
transform: [InFusion].0
2024/03/07 17:27:57 - infusion-staff - Initialising 1 transforms...
2024/03/07 17:27:57 - infusion-staff - Transform [InFusion.0] initialized
flawlessly.
2024/03/07 17:27:57 - General - From transform: InFusion, looking at 0
prev. transforms.
2024/03/07 17:27:57 - General - From transform: InFusion, looking at 0
prev. transforms.
2024/03/07 17:27:57 - General - Getting fields from transform: InFusion,
type=Rest
2024/03/07 17:27:57 - General - From transform: InFusion, looking at 0
prev. transforms.
2024/03/07 17:27:57 - General - From transform: InFusion, looking at 0
prev. transforms.
2024/03/07 17:27:57 - General - Getting fields from transform: InFusion,
type=Rest
2024/03/07 17:27:57 - infusion-staff - Data Set enabled? false
2024/03/07 17:27:57 - infusion-staff - Pipeline has allocated 1 threads and
0 rowsets.
2024/03/07 17:27:57 - InFusion.0 - Starting to run...
2024/03/07 17:27:57 - InFusion.0 - Signaling 'output done' to 0 output
rowsets.
2024/03/07 17:27:57 - InFusion.0 - Finished processing (I=0, O=0, R=0, W=0,
U=0, E=0)
2024/03/07 17:27:57 - infusion-staff - Pipeline duration : 0.071 seconds [
0.071" ]
Re: Pointers for.... basic web service API call
Posted by Bart Maertens <ba...@know.bi>.
That's correct, try adding a row generator transform that generates a
single rows before your rest client transform. that should do it.
Regards,
Bart
On Thu, Mar 7, 2024 at 1:29 AM Kai Börsch <KB...@insight-health.de>
wrote:
> Good morning David,
>
> it seems that there is no Input going into your transform. Do I get that
> correctly? This transform needs at least an empty input row to run.
>
> Otherwise it will always do nothing.
>
> Happened to me before until I realized.
>
> Kind regards
> Kai Börsch
>
>
> Gruß
>
> Kai
>
>
> ------------------------------
> *Von:* David McNeill <da...@mcpond.co.nz>
> *Gesendet:* Donnerstag, 7. März 2024 05:35
> *An:* users@hop.apache.org <us...@hop.apache.org>
> *Betreff:* Pointers for.... basic web service API call
>
> Thanks in advance to experienced Hop users.
>
> I'm trying to query a normal, well behaved API web service
>
> https://static.helpjuice.com/helpjuice_production/uploads/upload/image/6005/direct/1663303044502-Infusion%20Public%20API%20Version%201.pdf
> https://app.infusionbusinesssoftware.com/api/swagger-ui/index.html
>
> Is the Rest Client transform the correct input to use?
> https://hop.apache.org/manual/latest/pipeline/transforms/rest.html
>
> This particular web service takes two GET query parameters, not user/pass
> but session id and licence id, which I have. How do I configure these, or
> how do I create a custom transform that can correctly ask for these?
>
> When I try the REST client, from the Hop fat client, it doesn't actually
> do anything, it doesn't make an http query. I've set the URL, get method
> is GET, press play, launch.
>
> It tried changing the URL to just http://localhost:9090, and running a
> netcat nc -l 9090 listener, to see if it made any request at all. Nope,
> it's mute. Nothing going out. Log snip below.
>
> Ideally, I'd like to create an elegant connection definition that serves
> the web service above. Can anyone point to the correct type of doc on how
> to build one of these?
>
> Thanks,
> David.
>
>
>
>
>
>
>
> 2024/03/07 17:27:57 - InFusion.0 - Starting allocation of buffers & new
> threads...
> 2024/03/07 17:27:57 - InFusion.0 - Transform info: nrinput=0 nroutput=0
> 2024/03/07 17:27:57 - InFusion.0 - Finished dispatching
> 2024/03/07 17:27:57 - infusion-staff - Pipeline has allocated a new
> transform: [InFusion].0
> 2024/03/07 17:27:57 - infusion-staff - Initialising 1 transforms...
> 2024/03/07 17:27:57 - infusion-staff - Transform [InFusion.0] initialized
> flawlessly.
> 2024/03/07 17:27:57 - General - From transform: InFusion, looking at 0
> prev. transforms.
> 2024/03/07 17:27:57 - General - From transform: InFusion, looking at 0
> prev. transforms.
> 2024/03/07 17:27:57 - General - Getting fields from transform: InFusion,
> type=Rest
> 2024/03/07 17:27:57 - General - From transform: InFusion, looking at 0
> prev. transforms.
> 2024/03/07 17:27:57 - General - From transform: InFusion, looking at 0
> prev. transforms.
> 2024/03/07 17:27:57 - General - Getting fields from transform: InFusion,
> type=Rest
> 2024/03/07 17:27:57 - infusion-staff - Data Set enabled? false
> 2024/03/07 17:27:57 - infusion-staff - Pipeline has allocated 1 threads
> and 0 rowsets.
> 2024/03/07 17:27:57 - InFusion.0 - Starting to run...
> 2024/03/07 17:27:57 - InFusion.0 - Signaling 'output done' to 0 output
> rowsets.
> 2024/03/07 17:27:57 - InFusion.0 - Finished processing (I=0, O=0, R=0,
> W=0, U=0, E=0)
> 2024/03/07 17:27:57 - infusion-staff - Pipeline duration : 0.071 seconds [
> 0.071" ]
>
AW: Pointers for.... basic web service API call
Posted by Kai Börsch <KB...@insight-health.de>.
Good morning David,
it seems that there is no Input going into your transform. Do I get that correctly? This transform needs at least an empty input row to run.
Otherwise it will always do nothing.
Happened to me before until I realized.
Kind regards
Kai Börsch
Gruß
Kai
________________________________
Von: David McNeill <da...@mcpond.co.nz>
Gesendet: Donnerstag, 7. März 2024 05:35
An: users@hop.apache.org <us...@hop.apache.org>
Betreff: Pointers for.... basic web service API call
Thanks in advance to experienced Hop users.
I'm trying to query a normal, well behaved API web service
https://static.helpjuice.com/helpjuice_production/uploads/upload/image/6005/direct/1663303044502-Infusion%20Public%20API%20Version%201.pdf
https://app.infusionbusinesssoftware.com/api/swagger-ui/index.html
Is the Rest Client transform the correct input to use?
https://hop.apache.org/manual/latest/pipeline/transforms/rest.html
This particular web service takes two GET query parameters, not user/pass but session id and licence id, which I have. How do I configure these, or how do I create a custom transform that can correctly ask for these?
When I try the REST client, from the Hop fat client, it doesn't actually do anything, it doesn't make an http query. I've set the URL, get method is GET, press play, launch.
It tried changing the URL to just http://localhost:9090, and running a netcat nc -l 9090 listener, to see if it made any request at all. Nope, it's mute. Nothing going out. Log snip below.
Ideally, I'd like to create an elegant connection definition that serves the web service above. Can anyone point to the correct type of doc on how to build one of these?
Thanks,
David.
2024/03/07 17:27:57 - InFusion.0 - Starting allocation of buffers & new threads...
2024/03/07 17:27:57 - InFusion.0 - Transform info: nrinput=0 nroutput=0
2024/03/07 17:27:57 - InFusion.0 - Finished dispatching
2024/03/07 17:27:57 - infusion-staff - Pipeline has allocated a new transform: [InFusion].0
2024/03/07 17:27:57 - infusion-staff - Initialising 1 transforms...
2024/03/07 17:27:57 - infusion-staff - Transform [InFusion.0] initialized flawlessly.
2024/03/07 17:27:57 - General - From transform: InFusion, looking at 0 prev. transforms.
2024/03/07 17:27:57 - General - From transform: InFusion, looking at 0 prev. transforms.
2024/03/07 17:27:57 - General - Getting fields from transform: InFusion, type=Rest
2024/03/07 17:27:57 - General - From transform: InFusion, looking at 0 prev. transforms.
2024/03/07 17:27:57 - General - From transform: InFusion, looking at 0 prev. transforms.
2024/03/07 17:27:57 - General - Getting fields from transform: InFusion, type=Rest
2024/03/07 17:27:57 - infusion-staff - Data Set enabled? false
2024/03/07 17:27:57 - infusion-staff - Pipeline has allocated 1 threads and 0 rowsets.
2024/03/07 17:27:57 - InFusion.0 - Starting to run...
2024/03/07 17:27:57 - InFusion.0 - Signaling 'output done' to 0 output rowsets.
2024/03/07 17:27:57 - InFusion.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0)
2024/03/07 17:27:57 - infusion-staff - Pipeline duration : 0.071 seconds [ 0.071" ]