Re: Anyone Using Microsoft Graph Calendar APIs from the IBM i? -- MIDRANGE-L

Yep, that is the oauth method. If you make the callback to localhost or an
invalid URL you will get the code in the URI and you can strip it out to
use it to get a token and refresh token. Then after that it can be all
automatic and retrieved with GETURI (or HTTPAPI) and refreshed easily as
well.

I have also seen MS where you need to redo it if you change your password,
don't change your password for 6 months or so, or some random times where
it needs to be redone. That's why for my products I chose to go the route
of using a callback to make it easier. Otherwise it's quite an ordeal.
Google seems much more stable and better docs as well.

Here's some docs I have on how to do it with Google for a GMail app and
bypassing the callback:
https://docs.bvstools.com/home/greentools-for-google-apps/docs/g4g-gsuite-personal-registration

Not fun at all. Which is why I offer it as a product. In the time it
would take to figure all that out you could have paid for a few years of a
supported product. :)

Bradley V. Stone
www.bvstools.com
MAILTOOL Benefit #8 <https://www.bvstools.com/mailtool.html>: Email Logging
- Each email that is sent out is logged with a delivery status. MAILTOOL
also tracks each of the recipients for each email as well as the
attachment(s) sent along with each email.

On Thu, Apr 30, 2020 at 9:23 AM Tim Fathers <X700-IX2J@xxxxxxxxxxx> wrote:

There's the activation code option too, maybe that's how? I've done
something similar for a headless Twitter client with OAuth, but I can't
find the code at the moment.

Bruce is not wrong about the MS docs...!

________________________________
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of B
Stone <bvstone@xxxxxxxxx>
Sent: 30 April 2020 14:38
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Anyone Using Microsoft Graph Calendar APIs from the IBM i?

To be clear, the callback is only for the initial token and that can be
done manually, although it's a little messy.

After that there is no need for the HTTPS callback unless you need to
reauthorize an account (which I've found with MS can happen for any
reason). So I would be curious how he skirted it.

On Thu, Apr 30, 2020 at 5:43 AM Bruce Vining <bruce.vining@xxxxxxxxx>
wrote:

Tim,

Sure, but let me first talk to the Microsoft person here (my knowledge of
Microsoft is pathetic...) and see exactly how he configured my
program/requester. It runs as a batch job and is certainly headless.

On Thu, Apr 30, 2020 at 5:17 AM Tim Fathers <X700-IX2J@xxxxxxxxxxx>

wrote:

Bruce, I have to use the Graph APIs for a non-IBM i project, which will

be

a daemon job in the background sending and reading mail on behalf of a
user. Any chance I could pick your brains about the token requesting

in a

headless scenario (i.e. where I cannot redirect the user to a log-in

page)?

Cheers,

Tim.

________________________________
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of
Bruce Vining <bruce.vining@xxxxxxxxx>
Sent: 29 April 2020 23:12
To: Midrange Systems Technical Discussion <

midrange-l@xxxxxxxxxxxxxxxxxx

Subject: Re: Anyone Using Microsoft Graph Calendar APIs from the IBM i?

Just in case anyone finds this discussion, I do have Outlook cloud

calendar

creates, updates, and deletes working from the i. I am taking

advantage

of

the httpapi and yajl support that's available (thanks Scott), and,

hoping

that it will help someone some day, I'll simply say it wasn't that hard
(and that some of the Microsoft documentation is, well, not so great --

for

instance there isn't a need for a call back approach). My code,

needless

to

say, is **free RPG.

On Tue, Apr 21, 2020 at 5:40 PM B Stone <bvstone@xxxxxxxxx> wrote:

I have written interfaces for a few Office APIs (email, SMTP,

OneDrive).

Not Calendar yet, though (but I did for Google Calendar) as I

haven't

used

it personally or had requests for it.

You do need application permissions and OAuth 2.0 flow, which really

is

the

most challenging part, especially since microsoft requires a callback

for

the initial OAuth authentication. (this can be skirted with a few

tricks,

though).

My GreenTools for Microsoft Apps (G4MS) now uses the Graph APIs for
everything as well, so creating a calendar hook wouldn't be terrible.

I

believe you could even use the G4MS base for OAuth 2.0 like I have

set

up

for my Google API package as well. I could easily create a simple

calendar

package if you were interested with some basic functions.

Bradley V. Stone

https://eur04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.bvstools.com%2F&data=02%7C01%7C%7C8159eac151aa4978535c08d7ed0380f9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637238471606276263&sdata=gjQNQ3mKY0vXnbcFWnTGm910ytdS7w6i3KN5Jvd9ZYA%3D&reserved=0

GreenTools for PayPal <

https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.bvstools.com%2Fg4pp.html&data=02%7C01%7C%7C8159eac151aa4978535c08d7ed0380f9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637238471606286260&sdata=54046kpM23vKd%2Bua%2FisyyE1cDPMUGroDacSbS%2FS5q10%3D&reserved=0

:
Easily send

PayPal invoices from your IBM i applications using RPG ILE! Process
refunds, get account balances and more!

On Tue, Apr 21, 2020 at 3:31 PM Bruce Vining <bruce.vining@xxxxxxxxx

wrote:

I have the need to create and maintain cloud based Outlook

calendars

from

the i. The various calendar APIs (

https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fgraph%2Fapi%2Fresources%2Fcalendar%3Fview%3Dgraph-rest-1.0&data=02%7C01%7C%7C8159eac151aa4978535c08d7ed0380f9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637238471606286260&sdata=41MXLy%2Fqr%2BqnGTOov68Q4v0BNnBa17JBJjrh%2FEjo94c%3D&reserved=0

)
seem sufficient but I do have questions on configuration and hope

someone

out there has been down this path before.

First some background. Various dates and times are maintained on

the i

related to the progress of orders. Some of these dates and times
correspond to meetings that need to be held involving several

individuals

(who will vary based on the specific order). All of these

individuals

do

use Office 365/Outlook calendar and currently operators on the i

must

manually maintain these calendar entries whenever the date and/or

time

of

the meeting changes back in the i. What I want to do is capture

the

database changes and basically feed them through a *DTAQ to a job

(or

jobs)

that are using the Graph APIs to eliminate the manual approach

currently

being used. So far so good, all of the *DTAQ entries are getting

there

just fine. Now it’s time for the Microsoft Graph configuration

work…

In reviewing the Graph documentation it appears that I want to use

is

application permissions. Has anyone used such an approach? If so,

any

advice/examples/warnings to share? The company here has never set

anything

up for application permissions, I certainly never have, and I’m not
authorized to do any “playing around” on the Microsoft side so I

need

to

get the configuration “right” the first time. There are many

sites (

https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Factive-directory%2Fdevelop%2Fquickstart-configure-app-access-web-apis&data=02%7C01%7C%7C8159eac151aa4978535c08d7ed0380f9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637238471606286260&sdata=Vc6FoYEf2CLUu2TrGOGq7dQjKSZ4i%2Frahc0e2AReUUE%3D&reserved=0

being
one) that talk about setting up application permissions but I’m

concerned

that my use of terminology doesn’t exactly fit with Microsoft use

of

terminology, and there’s way too many warnings in the various sites

for

my

comfort (given my general feeling that I’m missing “something” due

to

these

terminology/conceptual differences).

Any guidance from those who have been here before?

Thanks,

Bruce

PS – I’m confident that using the Graph APIs will be “educational”

and

I’m

comfortable with that. I just want to make sure I’m not going

down a

bad

path in getting the two systems to talk with each other. That is,

getting

the basic networking configurations in place.

--
Thanks and Regards,
Bruce
931-505-1915
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)

mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:

https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&data=02%7C01%7C%7C8159eac151aa4978535c08d7ed0380f9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637238471606286260&sdata=zt27NhM1bznVtYFGLYIB1ywxIugOM9CEWLGL3H154KY%3D&reserved=0

or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at

https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fmidrange-l&data=02%7C01%7C%7C8159eac151aa4978535c08d7ed0380f9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637238471606286260&sdata=uED8z%2BopTNQTUHANzkuEAiWvZ39d3WqoN52LH4YymJg%3D&reserved=0

.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related

questions.

Help support midrange.com by shopping at amazon.com with our

affiliate

link:

https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Famazon.midrange.com%2F&data=02%7C01%7C%7C8159eac151aa4978535c08d7ed0380f9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637238471606286260&sdata=1troVK2vT8LbYvaqR8cJZHMOOoMn7oA8%2BIv8C47cR5I%3D&reserved=0

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)

mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:

https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&data=02%7C01%7C%7C8159eac151aa4978535c08d7ed0380f9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637238471606286260&sdata=zt27NhM1bznVtYFGLYIB1ywxIugOM9CEWLGL3H154KY%3D&reserved=0

or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at

https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fmidrange-l&data=02%7C01%7C%7C8159eac151aa4978535c08d7ed0380f9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637238471606286260&sdata=uED8z%2BopTNQTUHANzkuEAiWvZ39d3WqoN52LH4YymJg%3D&reserved=0

.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related

questions.

Help support midrange.com by shopping at amazon.com with our

affiliate

link:

https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Famazon.midrange.com%2F&data=02%7C01%7C%7C8159eac151aa4978535c08d7ed0380f9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637238471606286260&sdata=1troVK2vT8LbYvaqR8cJZHMOOoMn7oA8%2BIv8C47cR5I%3D&reserved=0

--
Thanks and Regards,
Bruce
931-505-1915
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:

https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&data=02%7C01%7C%7C8159eac151aa4978535c08d7ed0380f9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637238471606296254&sdata=FSLb80KWCFXd2Cot8fNAzy7j3xF0b2%2B0NJRhJnaP4h4%3D&reserved=0

or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at

https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fmidrange-l&data=02%7C01%7C%7C8159eac151aa4978535c08d7ed0380f9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637238471606296254&sdata=v4sl57syG2oVB0Fbk4gGwSPhc6DiGGzY6K1TH%2FuINMQ%3D&reserved=0

.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related

questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:

https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Famazon.midrange.com%2F&data=02%7C01%7C%7C8159eac151aa4978535c08d7ed0380f9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637238471606296254&sdata=839f78qJD4580Mdue3gKq2%2BXFi6hvYboJcV%2BSAnmaFE%3D&reserved=0

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:

https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&data=02%7C01%7C%7C8159eac151aa4978535c08d7ed0380f9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637238471606296254&sdata=FSLb80KWCFXd2Cot8fNAzy7j3xF0b2%2B0NJRhJnaP4h4%3D&reserved=0

or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at

https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fmidrange-l&data=02%7C01%7C%7C8159eac151aa4978535c08d7ed0380f9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637238471606296254&sdata=v4sl57syG2oVB0Fbk4gGwSPhc6DiGGzY6K1TH%2FuINMQ%3D&reserved=0
.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related

questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:

https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Famazon.midrange.com%2F&data=02%7C01%7C%7C8159eac151aa4978535c08d7ed0380f9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637238471606296254&sdata=839f78qJD4580Mdue3gKq2%2BXFi6hvYboJcV%2BSAnmaFE%3D&reserved=0

--
Thanks and Regards,
Bruce
931-505-1915
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:

https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&data=02%7C01%7C%7C8159eac151aa4978535c08d7ed0380f9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637238471606296254&sdata=FSLb80KWCFXd2Cot8fNAzy7j3xF0b2%2B0NJRhJnaP4h4%3D&reserved=0

or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at

https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fmidrange-l&data=02%7C01%7C%7C8159eac151aa4978535c08d7ed0380f9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637238471606296254&sdata=v4sl57syG2oVB0Fbk4gGwSPhc6DiGGzY6K1TH%2FuINMQ%3D&reserved=0
.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:

https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Famazon.midrange.com%2F&data=02%7C01%7C%7C8159eac151aa4978535c08d7ed0380f9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637238471606296254&sdata=839f78qJD4580Mdue3gKq2%2BXFi6hvYboJcV%2BSAnmaFE%3D&reserved=0

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.midrange.com%2Fmailman%2Flistinfo%2Fmidrange-l&data=02%7C01%7C%7C8159eac151aa4978535c08d7ed0380f9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637238471606296254&sdata=FSLb80KWCFXd2Cot8fNAzy7j3xF0b2%2B0NJRhJnaP4h4%3D&reserved=0
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchive.midrange.com%2Fmidrange-l&data=02%7C01%7C%7C8159eac151aa4978535c08d7ed0380f9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637238471606296254&sdata=v4sl57syG2oVB0Fbk4gGwSPhc6DiGGzY6K1TH%2FuINMQ%3D&reserved=0
.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://eur04.safelinks.protection.outlook.com/?url=https%3A%2F%2Famazon.midrange.com%2F&data=02%7C01%7C%7C8159eac151aa4978535c08d7ed0380f9%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637238471606296254&sdata=839f78qJD4580Mdue3gKq2%2BXFi6hvYboJcV%2BSAnmaFE%3D&reserved=0
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com