Re: Consuming Data From GCP to iSeries Directly

[Daniel Gross <daniel@xxxxxxxx>]

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.