Re: Consuming Data From GCP to iSeries Directly

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

Personally, in cases where that level of security is involved, I just use Scott's HTTPAPI along with DATA-INTO or YAJL.

There are other similar packages plus commercial offerings  


Jon Paris
Jon.Paris@xxxxxxxxxxxxxx



> On Jan 14, 2025, at 11:56 AM, Daniel Gross <daniel@xxxxxxxx> wrote:
>
> Hi Robert,
>
> consuming from the web is quite simple - using SQL functions like HTTP_GET and JSON_TABLE makes it easy. The hard part is doing the authorization part - like OAuth or JWT - this is not so simple, but doable.
>
> Do you mean Google Cloud Docs? (like Spreadsheets?)
>
> If you want, send some more specifications, and we can try to help.
>
> HTH
> Daniel
>
> > Am 14.01.2025 um 17:27 schrieb Robert Wenzel <robert.wenzel@xxxxxxxxx>:
> >
> > Apologies for not being RPG-specific with this question but I do not know
> > of another blog to ask the pros.  We are looking for a way to consume data
> > directly from Google Cloud to the iSeries.  Today we download the Google
> > data to our IFS then consume it using CPYFRMSTMF and CPYFRMIMPF but would
> > like a more direct solution.  Anyone have any suggestions without using an
> > expensive third-part software.
> >
> > --
> >
> > *Robert Wenzel, Senior Software Engineer*
> > Senior Software Engineer, iSeries Applications Support and Development
> >
> > [image: Inmar]
> > <https://www.inmar.com/?utm_source=email%20signature&utm_medium=email&utm_campaign=Associate%20Email%20Signature&utm_content=Inmar%20Logo>
> >
> >
> > robert.wenzel@xxxxxxxxx
> >
> > One West Fourth Street, Suite 500, Winston Salem, NC 27101
> >
> > www.inmar.com
> > <https://www.inmar.com/?utm_source=email%20signature&utm_medium=email&utm_campaign=Associate%20Email%20Signature&utm_content=URL%20link>
> > |  LinkedIn <https://www.linkedin.com/company/inmar> | Manage Email
> > Preferences
> > <https://go.inmar.com/unsubscribe-page?utm_source=email%20signature&utm_medium=email&utm_campaign=Associate%20Email%20Signature&utm_content=URL%20link>
> >
> > "The whole problem with the world is that fools and fanatics are always so
> > certain of themselves, but wiser people so full of doubt." - Bertrand
> > Russell
> >
> > --
> >
> >
> > ********************************************
> >
> >
> >
> >
> >
> > *Inmar Confidentiality
> > Note*:  This e-mail and any attachments are confidential and intended to be
> > viewed and used solely by the intended recipient.  If you are not the
> > intended recipient, be aware that any disclosure, dissemination,
> > distribution, copying or use of this e-mail or any attachment is
> > prohibited.  If you received this e-mail in error, please notify us
> > immediately by returning it to the sender and delete this copy and all
> > attachments from your system and destroy any printed copies.  Thank you for
> > your cooperation.
> >
> >
> >
> >
> >
> > *Notice of Protected Rights*:  The removal of any
> > copyright, trademark, or proprietary legend contained in this e-mail or any
> > attachment is prohibited without the express, written permission of Inmar,
> > Inc.  Furthermore, the intended recipient must maintain all copyright
> > notices, trademarks, and proprietary legends within this e-mail and any
> > attachments in their original form and location if the e-mail or any
> > attachments are reproduced, printed or distributed.
> >
> >
> >
> > ********************************************
> > --
> > This is the RPG programming on IBM i (RPG400-L) mailing list
> > To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/rpg400-l.
> >
> > Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.
> -- 
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.