►
From YouTube: Office Add-ins community call-August 2020
Description
August’s call, hosted by Alex Jerabek, featured the following presenters and topics:
Juan Balmori Labra showcased the Outlook JavaScript APIs coming to the next version of office.js.
Matt Geimer demoed the new single sign-on support in Office Add-ins.
Chris Mentor shared Jedox’s add-in solutions and talked with their team about the experience of building on the platform.
Resources:
WebView Switcher tool https://aka.ms/AA8xhut
Office Scripts https://aka.ms/office-scripts
Take the survey https://aka.ms/oadevsurvey
Stay connected
Twitter https://twitter.com/microsoft365dev
Blogs https://aka.ms/M365DevBlog
A
Welcome
to
the
microsoft
office,
add-ins
community
call
for
august
12th.
This
is
where
we
talk
about
everything
in
the
office
platform
related
to
extensibility,
whether
that's
office,
add-ins
office,
scripts
or
just
anything
else
that
makes
office
work
for
you
just
a
quick
bit
of
housekeeping.
Please
make
sure
your
microphones
are
muted
unless
you're
presenting.
If
you
want
to
ask
a
question
or
have
any
comments,
please
use
the
chat,
we'll
answer
them
as
we
go
through
and
have
a
q
a
at
the
end.
A
Members
of
the
office
headings
product
team
are
on
the
call
as
well
and
have
answer
all
of
your
questions.
As
we
go,
my
name
is
alex
robick
I'll,
be
the
host
for
today's
call.
We
also
have
juan
with
us
who's
going
to
talk
today
about
the
new
outlook,
1.9
apis,
to
show
off,
what's
about
to
be
released
into
general
availability
on
the
outlook
side
of
things
for
your
add-ins.
A
We
also
have
matt
here
to
talk
about
the
release
of
single
sign-in.
Sso
has
been
a
highly
awaited
feature,
so
we're
excited
to
present
that
to
y'all.
And
finally,
we
have
chris
one
of
our
friends
at
jdox
here
who
is
going
to
demonstrate
their
add-in
they've
released.
A
They
built
on
top
of
the
office
platform
and
they're
going
to
share
their
solution
and
their
you
know,
challenges
their
their
growth,
their
their
opportunities,
everything
that
went
along
with
developing
their
ad
in
with
y'all
and
then,
like,
I
said,
a
little
q
and
a
at
the
end
without
further
ado.
Let's
kick
it
off
with
juan
to
talk
about
the
outlook,
1.9
apis,
so
juan,
are
you
there.
B
C
Thank
you
very
much
alex
hello,
everybody.
It's
good
to
be
here
with
you
today
this
morning
here
in
redmond,
to
talk
a
little
bit
about
outlook
apis.
So
let's
go
through
it.
So,
basically
the
team.
What
the
team
is
working
on
right
now
is
that
we
are
closing.
C
You
know
the
scope
of
our
1.9
release,
so
the
new
apis
that
we
are
going
to
ship
for
the
new
javascript
apis,
we're
going
to
ship
to
outlook-
and
we
have
the
table
that
you
see
here-
includes
currently
the
scope
that
we
are
thinking.
We
are
going
to
release
so
it
includes
you
know
many
functionalities
that
you've
been
asking
for.
I
think
the
main
kind
of
the
main
feature
that
it's
gonna
get
released.
It's
a
penton
sent
depend
on
some
functionality
that
we
actually
reviewed
in
detail.
C
I
think
two
community
calls
ago.
I
strongly
suggest
you
to
go
back
to
to
that
one
and
see
you
know
what
we
shared
there,
but
we
are
also
including
other
apis.
I
guess
more
like
that.
We
have
been
getting
requests
in
our
user
voice
channel
quite
a
bit.
For
example,
we
are
we're,
including
some
the
dialog
api,
we're
going
to
provide
this
api
as
part
of
1.9
we're
going
to
have
what
we
call
display
item,
async,
flavors
and
finally,
we're
going
to
have
also
custom
properties.
C
Improvements
on
this
call
we're
going
to
talk
today
about
the
display
item,
async
flavors.
So
basically
we
have,
if
you
have,
if
you've
been
calling
without
look.
You
know
that
you
know
there's
a
bunch
of
apis
that
we
shipped
long
time
ago
that
are
about
displaying
items.
So,
for
example,
if
you
want
to
show
an
existing
appointment
or
an
existing
message,
you
want
to
pop
that
message
to
the
user
on
its
own
window.
C
You
basically
use
these
apis
to
either
show
an
existing
appointment
or
an
email,
or
you
can
also
trigger
the
creation
of
a
new
appointment
or
a
new
message
right
or
you
can
trigger
also
reply
or
reply
all
methods.
So
we
received
the
feedback.
So
we
go.
Let's
go
to
the
next
slide
and
see
why
why
this
apis
are
needed.
C
I
want
to
focus
this
presentation
today
on
these
methods,
so,
first
of
all
they
workship
long
time
ago,
and
in
fact
these
apis
they
have
a
problem,
but
actually
they
are,
they
have
advantages
and
disadvantages.
C
One
of
the
advantages
is
that
they
are
very
simple
to
use,
so
there
is
a
in
an
asynchronous
model.
This
is
one
of
the
few
synchronous
apis
and
basically
it's
very
simple
to
use.
You
just
write
display
you.
If
you
want
to
display
a
message,
takes
the
id
of
that
message
and
then
you
can
basically
just
show
it.
You
know.
Obviously
this
works
great.
C
If
the
item
already
exists
in
outlook
and
basically
when
we
designed
this
api
long
time
ago,
we
were
assuming
that
you
were
going
to
be
showing
existing
appointments
or
emails
right,
obviously,
with
that
with
the
graph
and
all
the
services
layers
that
we
have
today,
where
you
can
actually
create,
not
only
you
can
actually
create
not
only
using
the
javascript
api,
you
have,
you
have
rest
apis
and
you
have
the
graph
api
and
you
can
create
appointments
and
calendar
right
appointments
and
emails
using
the
rest
apis.
C
Okay,
so
basically
there's
a
the
problem
that
we
have
today
is
that
there's
kind
of
a
lagging
time
if
you
create
an
appointment
using
the
services
that
you,
you
might
not
have
the
item
created
in
outlook
yet
also
it
takes.
Sometimes
it
takes
you
like
a
few
seconds
or
sometimes
even
more
than
that.
Usually
it's
very
fast.
C
No,
but
sometimes
it
takes
some
time
and
basically,
if
you
have
a
synchronous
method
and
the
if
the
item
doesn't
exist
already
in
your
outlook,
then
this
api
is
going
to
fail
and
you
don't
you
don't
have
a
way
of
knowing
that
it
failed.
So
that
is
basically
the
problem
that
we
have
today.
So
we
are
adding
for
all
these
methods
a
way
to
check.
You
know
if
the
item
actually
was
created,
if
you,
if
you
can,
if
you
can
see
if
the
if
the
call
was
successful.
C
So
let
me
give
you
a
quick
demo
about
this.
Let
me
share
my
screen
and
show
you
how
this
works
really
quickly.
So
what
I
have
here
is
script
lab.
So,
as
you
know,
we
we
recently
announced
that
it's
it's
live,
so
you
can
now
use
scribbler
in
outlook.
I
will
share
in
the
meeting
notes.
You
know
a
link
to
this
snippet
so
that
you
can
play
with
it
as
well.
So
this
is.
This
is
basically
a
a
very
simple
snippet
that
is
showing
all
everything
that
I
just
mentioned.
C
So,
for
example,
here
I
have,
as
you
can
see
in
the
task
pane,
I
have
a
way
of
creating.
You
know
an
appointment
using
the
rest
api
or
a
draft
email
messages
using
the
rest
api,
and
then
I
have
a
way
of
showing
opening
an
appointment
using
the
old
apis
and
then
using
using
the
open
the
same
appointment
using
the
new
apis.
C
So
let's
have
a:
let's
have
a
look
at
the
code
here.
So,
as
I
was
telling
you
the
apis
that
we
shipped
a
long
time
ago,
you
see,
if
you
see,
line
number
17
here,
you
will
see
we
have
displayed
appointment
and
it's
basically.
C
What
I'm
doing
is
that
I'm
just
taking
an
id
as
a
parameter,
and
then
I
just
opened
that
one
right,
but
you
don't
have
a
way
of
checking
if
it
was
successful
or
not,
so
it
was
kind
of
unreliable.
You
know,
as
you
can
see
the
difference
here
in
the
new
method.
We
actually
have
an
async
flavor.
That's
why
why
the
you
know
the
async
prefix
is
here.
C
Suffix
is
here
it
takes
the
id
of
the
appointment
that
you
want
to
create
and
then
basically
you
get
a
call
back
and
within
the
callback
you
can
actually
check.
You
know
if
the
item
exists
or
not
all
right,
then
I
have
another
two
methods
here
to
create
appointments.
I
was
trying
to
simulate
what
is
the
problem
here,
although
I
wasn't
able
to
do
that
right
now.
The
graph
is
very
fast,
so
I
cannot.
C
I
cannot
replicate
it,
but
you
know
in
some
conditions
and
if
you're
using
ews
as
well,
it's
sometimes
you
get
this
this
behavior.
What
I'm
doing
here
is
I'm
just
calling
the
rest
api
and
creating
a
new
appointment,
and
then
I
am.
I
am
basically
opening
that
item.
Using
using
the
the
methods-
oh
so,
let's,
let's
see
how
it
works
here,
so
I
will
first
of
all
I'm
going
to
create
a
draft.
C
So
when
I
click
on
create
draft,
you
will
see
that
effectively
the
well
you
can
see
it
was
very
fast
right
now,
so
we
went,
it
went
to
the
graph
create
a
new
draft.
C
I
have
the
id
here
and,
as
you
can
see
the
drafts-
and
if
I
open
my
drafts
folder,
you
will
see
that
effectively.
There's
a
draft
created
here,
so
this.
D
C
Was
very
fast,
you
know
it's
just
it's
very
creative.
I
was
not
able
to
replicate
this,
but
some
customers
have
reported
that
this
frequently
happens.
So
I
don't
have
the
problem
right
now,
but
I
want
to
show
you
what
happens
if
I
delete
it.
If
I
now,
I'm
going
to
create
a
new
appointment
so
by
creating
the
rest
apis
and
as
you
can
see
here,
this
is
the
appointment
that
I
created,
and
basically
here
is
the
id
of
that
appointment
and
I'm
reporting
the
id
here
in
the
console
right.
C
C
If
I
delete
the
appointment
check
this
out,
let's
go
to
the
calendar,
so
I'm
going
to
open
this
in
a
new
window.
This
is
the
appointment
that
was
created,
I'm
just
going
to
delete
it,
so
it
no
longer
exists.
C
So
if
I
cr,
if
I
try
to
open
that
appointment
using
the
id
that
was
provided
originally
using
the
alt
method,
I'm
just
going
to
basically
just
going
to
be
making
the
call-
and
I
don't
have
a
way
of
knowing.
If
what
happened
you
know,
I
don't
know
if
this
was
successful
or
not
as
a
developer.
So
this
is
basically
the
complaint
that
we
were
listening.
C
However,
if
I
create,
if
I
use
the
new
method,
on
the
other
hand,
I'm
going
to
be
able
to
say
hey,
I'm
going
to
get
this
exception,
I'm
going
to
I'm
going
to
check.
You
know
the
call
failed.
You
know
the
the
item
does
not
exist
and
has
not
been
created.
So
this
is
a
very
it's
a
more
reliable
api
in
the
sense
that
you
you
can
get.
C
You
know
a
detailed
response
on
why
you
know
if
that,
if
the
item
was
was
displayed
or
not
all
right,
so
we
implemented
this
flavor
of
asynchronous
to
all
the
displays
or
again
we
have
like
six
methods
that
are
displaying
items
in
outlook
and
in
1.9.
C
They're
gonna
have
an
async
flavor
so
that
you
can
actually
check
if
the
items
were
created
or
not,
and
that's
what
I
have
for
you
guys
today
by
the
way
everything
that
I
was
saying
right
now,
it's
in
preview,
so
you
can
go
and
try
use
this
apis.
Give
us
feedback
again.
We
are
in
the
latest
stages
of
you,
know,
shipping,
all
these
new
functionalities
for
you,
and
it
will
be
wonderful
if
we
can
get.
You
know
your
your
feedback
on
it.
A
C
Where
it's
going
to
be
very
soon
again
we're
closing
the
scope
of
this.
We
are
polishing
everything
the
last
details,
making
sure
that
it
works
in
the
platforms
that
we
are
targeting
by
the
way.
This
is
only
gonna
work
for
for
now
in
windows
and
ola
and
web
later,
it's
going
to
work
in
mac
and
the
other
platforms,
but
you
know
I
I
I
don't
want
to
say
a
specific
date,
but
but
I
think
it's
going
to
be
very
soon,
so
I
hope
that's
what
you
know.
A
B
Thanks
alex
so
hey
happy
to
be
here,
happy
to
announce
that
we
have
released
single
sign-on
for
office
add-ins,
they
have
gone
ga,
so
it's
really
exciting
and
I'm
really
happy
to
share
a
little
bit
about
what
what
the
single
sign-on
feature
does
and
how
we
can
how
we
can
use
it
just
a
little
overview.
It
is
generally
available
and
it's
available
in
the
july
fork.
So
that's
gonna
be
rolling
out
over
the
next
few
weeks.
B
I
believe
to
the
current
channel
and-
and
you
know,
keep
an
eye
on
that,
but
I
believe
it's
version
2008
the
identity,
api
requirements
set
does
list
the
build
and
if
it
doesn't
we'll
make
sure
we
update
that
specific
build.
But
I
know
it's
version
2008.
You
know
single
sign-on.
I
love
the
chat
by
the
way.
This
is
great.
The
single
sign-on
lets
you,
you
know,
reduce
the
number
of
times
the
user
has
to
log
in
to
to
your
service.
B
If
they're
already
logged
into
office
and
you're
using
azure
active
directory-
and
it
really
provides
a
smoother
user
experience-
and
you
can
also-
you
know-
really
easily
get
profile
information
or
you
can
get
microsoft
graph
data
depending
on
what
your
service
needs
to
do.
A
really
nice
thing,
too,
is
that
it
supports
both
work
and
school
accounts,
as
well
as
microsoft
accounts.
So
it's
not
just
for
organizations,
it's
not
just
for
consumers.
You
can
use
it,
no
matter
who
you're
targeting.
B
I
just
want
to
talk
a
little
bit
about
how
how
the
flow
works-
and
you
may
have
seen
this
before
and
we'll
just
kind
of
go
through
it
real
quickly,
but
you
have
an
add-in
on
the
client
side
and
that
go
goes
ahead
and
creates
a
request
to
get
access
token.
So
this
is
the
call
that's
saying
hey.
I
want
to
know
who
this
user
is
that
goes
ahead
and
calls
out
to
azure
ad,
so
the
office
host
is
calling
out
to
azure
id
to
get
a
token
for
the
add-in
server.
B
So
this
is
your
server
and
what
happens
is
it
returns?
We
go
ahead.
You
know
and
move
move
forward
that
to
back
to
the
client
side,
that's
the
step.
Three
get
back
token
to
your
admin,
server
to
the
office
host
that
comes
back
to
the
client.
So
then
you
can
go
ahead
and
use
that
now
you
have
the
user's
identity.
They've
consented
already
at
this
point
or
an
admins
consented
so
that
that's
taken
care
of
and
the
client
side
can
pass
it
back
to
the
server
for
validation.
B
You
know
you
can
use
that
information
to
store
information
on
your
server
side
or
you
can
continue
on
and
do
steps
six
through
eight
here
which
show
how
to
get
to
graph
data.
So
you
can
exchange
that
token,
using
the
on
behalf
of
flow
to
get
a
graph
token
and
make
calls
to
the
graph.
So
you
can
go
ahead
and
it
just
bit.
You
know
you
literally
just
make
another
call
on
your
server
side.
Six,
seven
and
eight
just
show
yeah.
You
know
you
can
go
ahead.
B
Exchange
that
token
and
then
you
get
access
to
the
graph
and
you
can
make
craft
calls.
So
that's
the
flow!
It's
it's
very
straightforward,
as
we
can
see
here
with
the
lines,
it's
actually
pretty
straightforward
to
implement
I'll
show
you
a
little
demo
here.
B
I
have
two
demos
for
you.
So
first,
let's
take
a
look
at
a
very
simple
single
sign-on
demo
here,
so
I
have
just
used
the
yo
office
tooling
to
create
a
very
excel
task.
Pane
add-in
and
I
added
a
few
lines
of
code.
Specifically,
I
added
this
get
access.
Token
there's
a
couple
options
I
passed
here,
I'll,
allow
sign
in
and
allow
consent,
and
so
allow
consent.
B
Prompt
is
a
big
one.
Actually,
that's
something
we
added
where
the
user
can
consent
to
share
the
profile
information
if
they,
if
they
they
haven't
yet.
So
that's
that's
something!
That's
really
important
that
we've
added
that's
for
the
identity
piece,
the
profile
piece,
only
if
you're
looking
to
do
graph
scopes,
we'll
talk
about
that
in
a
minute.
B
I
parsed
that
token-
and
I
just
you
know,
went
ahead
and
grabbed
some
some
range
data
and
threw
it
into
a
into
a
range.
So
let's
take
a
look
at
how
this
works.
I
need
to
make
sure
I'm
running
the
right.
One.
They're
very
closely
named,
unfortunately,
looks
like
that
is
running,
so,
let's
launch
excel.
B
This
is
an
excel
one.
We
can
see
that
I
have
a
few
different
accounts
signed
in
here,
so
I'll
show
you
kind
of
some
different
experiences,
so
this
is
just
the
the
simple
again.
I
I
just
modified
the
sample
app.
I
click
run.
Oh
I
got
I
have
to
select
my
range.
I
didn't
care
should
scold
me
for
this.
We
can
see
here
that
it
went
ahead
and
it
grabbed
just
by
clicking
that
run
that
one
call
to
get
get
token
get
access
token.
You
can
also
see
when
I
set
up
my
tenant.
B
I
misspelled
my
own
name,
which
is
hilarious,
but
what
we
can
see
here
this
I'm
parsing
that
token
I'm
getting
the
the
from
I'm
just
showing
you
the
the
scope
scopes.
I've
got
here,
the
audience,
that's
my
my
app
id,
which
I
can
see
matches
my
app
id
in
azure,
which
right
here
we're
not
gonna.
You
know
copy
it
and
take
a
look,
but
it
is
the
same
app.
B
We
can
see
just
like
that.
It's
getting
the
the
correct
person
super
easy
that
was
again
that
one
line
of
code
is
is
calling
and
getting
that
token
I
didn't
have
to
do
anything
but
parse
it.
So
all
that's
handled,
I
will
call
out.
I
did
not
put
in
a
fallback
method
here,
so
you
should.
You
should
definitely
do
that.
We'll
see
what
that
looks
like
here
in
the
next
demo,
which
the
next
demo
is
using,
the
the
actual
tooling
again,
that
does
the
sorry,
the
sso,
quick
start
that
we
have.
B
So
we
have
a
really
cool
sso,
quick
start.
It
goes
ahead
and
creates
a
really
nice
project
for
you
and
it
can
even
register
the
the
azure
active
directory
app
registration.
So
you
can
go
through
all
the
pieces
for
that
and
you
can.
This
is
that
that
that
project
right
here
I
did
not
change
this
at
all.
I
just
wanted
to
show
you
this.
B
This
took
me
maybe
like
20
minutes,
to
put
everything
together,
and
most
of
that
was,
you
know,
waiting
for
the
azure
command
line
to
download
and
go
through,
but
it
goes
ahead.
It
has
some
really
nice
helper
libraries
in
there
to
go
ahead
and
do
the
fallback
off
to
handle
all
the
things
that
you
should
be
doing
so,
if
you're
just
getting
started,
this
is
a
great
place
that
you
can
go
and
see
how
that
works.
B
So,
let's
go
ahead
and
see
who
I'm
logged
in,
as
so
I'm
logged
in
right.
Now,
as
my
misspelled
user,
I
can
go
ahead
and
try
and
do
this
now.
What's
going
to
happen,
is
this:
this
should
fail,
that's
expected.
So
this
is
the
fallback
dialogue.
So
this
is,
if
sso,
for
whatever
reason,
didn't
work
and
there's
a
couple
scenarios
where
this
could
be
either
they're
in
a
the
user's
in
an
older
version
that
doesn't
support
sso
or
there's.
You
know
some
error
that
wasn't
handled
now.
B
In
this
case
again,
we
have
a
a
few
of
them
in
the
the
tooling,
the
the
quick
start
that
are
automatically
handled,
but
there
are
some
some
cases
like
multi-factor,
auth
and
conditional
access
that
you
need
to
be
careful
about,
and
we
do
have
some
documentation
on
that
on
how
to
handle
that.
So
this
is
an
expected
behavior.
You
want
to
make
sure
that
you
do
have
this
fallback
method
to
let
the
user
go
ahead
and
then
sign
in
the
first
time
which
they
have
to
do
to
go
through
the
the
consent
process.
B
But
what
I'm
going
to
do
is
I'm
going
to
go
back
to
my
portal
here,
and
this
is
the
other
app
that
we're
looking
at
right
now
that
word
app
and
we
can
see
here,
I
I
can
actually
go
ahead
and
grant
admin
consent
for
my
entire
tenant,
and
so
I've
done
that
and
now
what
assuming
that
this
propagates
quick
enough,
we'll
see,
let's
see
if
this
works
boom,
so
there
you
go
and
I'm
a
super
cool
demo
person.
I
totally
didn't
put
that
in
for
this
demo.
B
Oh,
I
did
actually,
but
this
is
showing
off,
like
your
office
information,
your
phone
number.
You
know
this
is
again
just
just
some
basic
profile
info,
but
you
can.
This
is
getting
it
from
from
graph,
so
this
is
going
through
that
whole
flow
of
the
getting
the
profile
token
swapping
it
for
a
graph
token
talking
to
graph,
and
we
also
have
a
different,
a
different.
B
I'm
sorry
addition
to
the
quick
start
that
tells
you
how
to
modify
it
to
go
and
get
other
graph
data
and
and
using
that
as
a
great
learning
tool,
so
really
cool
stuff.
I
think
that
covers
most
of
it.
I
know
I
missed
one
thing:
actually,
let's
go
back
to
that
other
demo.
Let's
see
if
I
can
get
the
consent
experience
real
quick
just
so
you
can
see
what
it
looks
like.
So
in
the
case
of
the
the
previous
well,
we
just
saw
that
with
admin
consent.
B
That
is
what
you
have
to
do
for
a
graph
graph
scopes.
If
you
have
graph
scopes
just
for
certain
issues
that
we're
still
working
out
and
trying
to
move
through
with
with
some
of
the
consent
parts,
the
the
admin
consent
is
the
only
way
that
you
can
avoid
a
fallback,
but
with
the
if
you're,
just
using
profile,
you
can
still
do
consent
right
here
in
clients.
Let's
see,
I
think
this
one
should
work
to
ask
for
consent.
B
B
Well,
you
know
what
I'm
not
going
to
show
you
the
consent
experience
this
time,
but
I'll
go
make
sure
that
if
anyone
wants
to
see
it,
we
can
go
through
that
next
time,
where
we'll
put
something
up,
you
know,
after
on
the
docs,
just
showing
what
that
looks
like,
but
that's
pretty
much
the
as
easy
as
it
is
you
you
really
don't
have
to
do
much
that
one
line
that
get
get
access
token.
B
It
really
is
that
simple
just
get
the
profile
information
you
do
have
to
do
your
app
registration,
the
the
full
details
are
on
the
on
the
documentation
and
which
we
do
have
links
to
in
this
deck
and
we'll
make
sure
we
share
out
they're,
also
in
our
announcement
on
the
office,
dev
blog
post,
so
just
a
couple
of
best
practices
make
sure
to
implement
that
fallback
method.
If
you
don't
yeah,
you
won't,
let
users
be
able
to
sign
in,
and
that's
that's
not
a
great
experience.
B
There
are
client
ids
you
have
to
pre-authorize
so
that
the
office
host
can
do
the
the
call
on
the
on
on
the
behalf
of
the
user
and
talk
to
your
service.
So
you
have
to
you,
do
have
to
pre-authorize
that,
and
the
list
again
is
in
our
documentation.
There
are
some
new
formatting
requirements
for
the
manifest
that
we're
we're
finishing,
updated
documentation
this
week,
but
it
does
follow
the
best
practices
that
are
already
there
in
the
current
docs,
we'll
just
be
calling
out
that
they
are
now
required
and
then
there's
some
things.
B
We'll
make
sure
that
if
you
do
use
graph
scopes-
and
you
do
get
graph
data
that
you
you
will
be
able
to
fail
fast
if
they
didn't
have
admin
consent
granted
already
so
we'll
just
skip
even
trying
to
get
a
token
that
won't
work
and
we'll
go
ahead
and
say:
hey,
like
you
know,
let's
launch
that
fallback
method
the
first
time
and
then
after
that
consent
will
have
been
granted
and
it
should
just
work
and
then
for
the
other
piece
like
I
said,
the
consent
prompt.
B
If
you
only
require
profile
information,
make
sure
that
you
include
that,
so
you
can
get
the
most.
The
most
value
out
of
sso,
so
that's
that's
what
I
had.
I
will
answer
questions
in
the
chat
here
after
you
know,
after
I'm
done
talking,
which
is
right
now,
if
you
have
anything
else,
though,
make
sure
to
check
out
our
documentation,
like,
I
said,
a
blog
post
and
we'll
be
continuing
to
do
some
some
additional
work
on
this
and
and
improve
the
experience
as
we
move
forward
thanks
so
much.
A
All
right,
thank
you,
so
much
matt
and
yeah
feel
free
to
ask
questions.
Chat,
matt
will
be
hanging
out
throughout
this
and
we
can
kind
of
revisit
some
of
the
ones
we
want
to
talk
more
about
during
the
q
a
section,
but
for
now,
let's
switch
over
to
chris
mentor
is
going
to
talk
about
jadox's
add-in
their
their
solution.
So
chris
are
you
there?
Yes,.
D
I
am
yeah
hello,
everyone,
chris
mentor,
I'm
the
director
of
product
management
at
jedox
today
is
a
little
bit
of
a
discussion
about
a
real
life.
Implementation
of
office.
Js
and
custom
functions
we're
a
a
technology
company
that
does
corporate
performance,
cpm
performance
management.
So
we
do
planning
forecasting,
budgeting,
reporting
and
analysis
for
companies
and
basically
so
what
we've
developed
is
we've
for
a
long
time
since
2002
we've
had
an
excel
add-in
for
our
product
and
we've
recently
developed
a
jedox
online
add-in.
D
D
The
add-in
is
available
for
anyone,
but
you
need
a
jet
ops
instance
to
actually
run
it.
You
can
download
it
from
the
from
the
appsource
marketplace
and
add
that
to
your
instance
of
excel
online
and
the
first
screen
you
get
when
you
get.
It
is
a
is
a
screen
which
basically
tells
you
either
add
a
connection,
or
you
can
just
get
a
trial
version
on
the
fly
of
jet
ox
and
connect
to
that
to
actually
start
looking
at
your
data
via
excel
online.
D
So
what
I'm
going
to
do
now
is
swap
over
live
to
to
a
demo.
So
when,
when
I
come
to
manage
my
connections,
I
can
click
on.
This
is
my
jedox
toolbar
here
in
my
ribbon.
At
the
moment,
we've
only
got
a
couple
of
items
over
time.
This
will
be
built
out
to
include
a
fully
featured
ribbon
that
we
have
for
excel
at
the
moment,
desktop
excel
and
at
the
moment,
we're
building
this
up
and
we've
got
the
ability
to
manage
connections.
D
D
Another
example
here
of
another
type
of
user.
So
if
I
want
to
say
a
business
analyst
view
here,
they've
got
a
report
that
they
need
to
key
numbers
in.
They
could
select
various
filters
or
groups.
I've
got
a
budget
number.
I
want
to
increase
that
to
a
thousand
they
just
type
that
number
directly
in
and
that
sends
the
number
directly
into
the
jedox
database,
and
we
can
see
here.
We've
got
these
parlo
data
c
formulas.
They
are
a
jedox
formulas
using
custom
functions
that
are
connecting
back
to
this.
D
D
So
this
this
is
a
bit
of
an
example
of
how
how
these,
how
these
formulas
work
and
how
we're
using
custom
formulas
to
actually
return
data
from
a
jedox
olap
server.
D
In
memory
olap
server
in
the
cloud
to
excel
online
next
thing
I
wanted
to
show
you
was
taking
a
report
here
in
excel,
so
this
is
we're
now
in
desktop
excel,
and
this
is
an
example
of
a
fully
fledged
jedox
ribbon
here
in
desktop
excel
most
of
our
customers
use
and
again
the
ability
to
change
to
various
regions
to
see
to
see
the
data
changing.
I
can
key
in
another
number
here
and
that's
gone
straight
into
the
system,
but
what
I
can
do
now,
of
course,
is.
D
I
can
just
open
up
that
report
that
I've
got
from
that's
actually
here
in
desktop
excel.
I
can
open
up
that
report
online,
so
same
report,
I've
saved
into
one
drive
and
then
I
can
open
this
up
directly
here
into
one
into
excel,
excel
online
here
and
displaying
my
information.
D
A
D
E
Yeah
no
worries
so
vlado
here,
hi
everyone-
I
don't
know
if
you
can
see
me
yeah,
so
we,
for
example,
it's
custom
function,
so
we
are
using
custom
function,
talking
back
to
our
to
our
cloud
backend.
So
that's
what's
happening
in
the
back.
I
don't
know
the
the
experience
we've
been,
we've
been
talking
to
peer
carer
and
the
whole
team
for
quite
a
long
time
following
the
development
of
this
before
it
was
ga
watching
closely
what's
happening,
and
obviously
we
have
a
huge
investment.
E
You
know
with
a
huge
investment
in
in
this
we've.
Been
we've
been
working
on
this
since
2002
and
we're
now.
You
know
this
is
the
the
next
next
next
step
to
to
to
convert
this
to
custom
function,
functions
which
obviously
has
a
has
a
huge
potential
for
our
customers,
because
it
has
a
much
much
bigger
reach.
E
You
know,
being
able
to
finally
being
able
to
to
develop
once
and
have
experience
both
in
excel
online
mac,
desktop
and
and
and
obviously,
windows
yeah
in
a
single
single
with
a
single
code
base
yeah.
So
that's
it's
really
awesome
and
and
team
was
very
helpful.
Helpful
k
over
and.
A
Awesome.
Thank
you.
Thank
you
for
sharing
that
yeah,
cool
and
yeah.
Everyone
will
be
around
in
the
chat
if
you
have
questions
about
yeah,
like
development
or
or
the
jdx
ad
in
general,
feel
free
to
ask
them
so
I'll
switch
over
back
to
the
slides
and
yeah
like,
like,
I
said,
we'll
do
the
q
a
part.
Now
there
is
one
question
that
came
in
repeatedly
online,
I
think,
was
in
the
chat
earlier.
It
was
about
using
the
new
edge
webview
too.
So
I'll
just
leave
these
instructions
up
here.
A
For
now
this
is
the
new
webview
controller.
That's
you
know
using
the
latest
version
of
chromium
and
all
that.
Well,
I
also
saw
a
question
in
the
chat
earlier
that
you
know.
Will
this
be
connected
to
the
like
visual
studio
code,
extensions
and
debugger
extensions
and
yeah?
That's
there
is
an
option
there
for
an
edge,
webview
debugger
as
well
so
and
yeah,
I
think
that's
cara.
Did
you
want
to
say
anything
else
to
webview2
while
you're?
I
know
you're
answering
some
questions
earlier.
F
I
I
think
the
team
will
have
a
blog
post,
cd
or
runtime
pm
will
be
outlining
a
blog
post.
As
the
sled
says
hey.
It
is
now
available
on
insiders.
I
think
really
for
us
to
hit
our
goal
of
bringing
this
to
become
generally
available
in
the
fall.
We
really
need
your
help
here.
This
is
a
huge
change
and
a
change.
F
We
think
for
the
better
so
like
on
this
front,
hey
the
more
help
we
can
have
in
terms
of
testing
on
the
insider's
channel,
which
they
also.
F
I
think
there
was
a
recent
name
change,
so
you
may,
it
may
be
called
office
beta
as
well,
but
the
more
help
you
can
do,
the
better
we
will
be-
and
I
think,
a
couple
months
ago
we
even
announced
the
shared
runtime
starting
with
excel
and
we'll
bring
the
shared
runtime
to
the
other
host
as
well
and
right
now
the
shared
runtime
is
still
using
ie,
but
our
hope
is
hey.
F
Once
the
new
edge
webview
to
control
does
ga
shared
runtime
will
move
to
that
as
well,
and
so
we
think
hey.
This
is
going
to
be
a
huge
leap
forward
in
terms
of
your
developer
experience,
as
well
as
just
providing
better
capabilities
for
end
users.
A
B
Yeah
sure
I
mean
the
the
there
were
some
great
questions
you
know
asking
if
it
was
sample
2.
No,
it's
not
sample
2.
There
was
a
question
about
you
know:
is
this
just
for
azure
id
services
or
does
it
work
for
other?
You
know
identity
providers
and
it
is
just
azure
id
services
right
now.
You
know
that
folks
are
looking
to
do
things
with
other
providers.
B
You
know
we
do
still
recommend
that
you
do
the
dialogue
api,
which
is
how
you
should
also
most
likely
also
implement
your
fallback
using
something
like
msl,
a
couple
implementation
questions.
You
know
other
implementation
questions,
but
I
don't
think
there
was
anything
else
that
I
saw
no
looks
pretty
good.
A
Awesome,
thank
you
matt
and
yeah.
As
to
the
the
powerpoint
questions
that
are
out
there,
we,
we
are
actively
looking
at
expanding
powerpoint
apis
right
now
beyond
the
common
api
service
that
works
for
any
add-in
and
the
like,
as
matt
mentioned,
the
one
create
presentation
function.
We
are
looking
into
that.
We
don't
have
a
timeline
right
now,
but
like
as
karen
mentioned
user
voice
is
how
we
prioritize
api
requests.
A
So
if
there's
a
particular
function,
particularly
like,
if
you
were
using
it
in
an
existing
com,
add-in,
let
us
know-
and
you
know,
go
upvote
that
request.
We
can
prioritize
our
releases
of
apis
based
on
that.
So,
yes,
let
us
know,
but
we
are
working
on
powerpoint.
We
are
investigating
new
apis
and
figuring
out
how
to
best
deliver
a
set
that
will
help
the
most
people
so
yeah.
A
Your
input
in
that
is
invaluable,
and
we
will
announce
on
this
call
when
we
have
stuff
for
people
to
preview
to
try
out
in
script
lab
and
such
so
yeah.
Thank
you
one
other
thing
I
wanted
to
mention
aside
from
engaging
with
us.
If
you
are
interested
in
presenting
during
an
upcoming
call-
or
you
know,
giving
us
feedback
of
any
kind
or
questions
you
know
go
to
ms
office
add-ins
engage
we'll
also
share
the
link
to
submit
questions
for
the
q
a
ahead
of
time,
a
lot
of
questions
that
were
required.
A
A
lot
of
detailed
answer
and
kind
of
civic,
so
we'll
post
them
in
the
blog
post
coming
up
melody
will
share
the
link
to
that
or
where
you
can
find
the
blog
post
coming
up.
We
also
sylvia
our
developer
experience
pm
put
together.
Another
survey
around
developer
satisfaction,
so
we
really
want
to
hear
about
your
experiences
building
office
add-ins
from
start
to
finish.
So,
if
you
could
head
over
to
ms
office,
dev
satisfaction
fill
out
the
quick
form
there
and
let
us
know
kind
of
what
your
experiences
were
with
the
platform.
A
All
right
were
there
any
other
questions,
anything
else.
Wanna
care
matt.
You
wanna
share
before
we
head
off.
B
No
I'm
good
thanks
so
much
for
for
having
me
on
this
call
alex.
It
was
great
super
happy
to
be
here
and
share
the
info.
Of
course.
Thank
you.
C
A
A
Oh,
thank
you
yeah,
so
for
those
of
you
on
the
call
who
are
new
to
office
add-ins,
who
this
maybe
is
your
first
exposure.
If
you're
interested
in
starting
to
extend
the
office
platform,
we
have
some
quick
starts.
That'll,
get
you
up
and
running
with
a
working
add-in
in
five
minutes
or
less
head
over
to
ecms
office
add-in
stocks,
you
can
start
playing
around
for
quick
starts.
We
also
have
tutorials
there,
including
the
sso
quick
start,
so
you
can
start
trying
out
that
feature.
A
If
you're
looking
for
a
lighter
automation
solution,
you
don't
need
a
full-fledged.
You
know
web
service,
add-in
you're,
just
looking
to
automate
some
tasks
in
excel.
I
recommend
checking
out
office
scripts.
The
feature
is
in
preview
right
now.
You
can
learn
all
about
that
at
ms
office
scripts
docs.
We
also
have
numerous
resources
for
y'all.
If
you
are
interested
in
getting
an
office
development
tenant
and
starting
to
try
out
these
scenarios
without
having
an
enterprise.
A
Ten
of
your
own
head
over
to
the
microsoft
365
developer
program,
there
you
can
get
a
tenant
and
get
more
resources
to
help
start.
Your
development
process
also
feel
free
to
engage
with
us
on
stack
overflow
on
github
user
voice
like
we
mentioned,
we're
monitoring
all
these
channels,
and
we
want
to
hear
your
experiences
and
help
you
out.
Finally,
there
are
other
developer
community
calls
out
there
in
the
microsoft
365
ecosystem.
A
This
is
just
a
quick
list,
but
yeah
if
you're
interested
in
developing
for
teams
or
sharepoint
check
out
those
calls
they're,
either
monthly
or
bi-monthly,
so
yeah
check
them
out
today.
So
thank
you.
All
this
recording
will
be
available
on
our
m365
developer.
Youtube
channel,
we'll
go
up
sometime
soonish,
along
with
a
blog
post,
that'll,
have
the
questions
and
answers
from
the
chat
and
any
questions
that
we
didn't
get
to
during.
This
call
we'll
have
answers
on
the
blog
post.