►
Description
In this 12-minute developer focused demo, KPMG MVPs Marco Amoedo and Mario Trueba explain how LibreBor APIs retrieve company details from the Spanish Register. Organizational information such as acquisitions, incorporations, Directors, NIF (Tax Identification Number) validation and more. Their LibreBor connector in preview, retrieves information from LibreBor APIs and makes it available in Logic Apps, Power Apps and Power Automate. Example shown. Natalie Pienkowska reports there are now 72 Independent Publisher Connectors in production and 42 in the pipeline today! This PnP Community demo is taken from the General Microsoft 365 Developer community call recorded on March 3, 2022.
Demo Presenters:
• Natalie Pienkowska (Microsoft) | @NataliePienkow1
• Marco Amoedo (KPMG) | @marcoamoedo
• Mario Trueba (KPMG) | @MarioTrueba365
Supporting materials:
• Documentation - LibreBor (Independent Publisher) (Preview) | https://docs.microsoft.com/connectors/libreborip/
• Repo - Libre Bor Connector | https://github.com/microsoft/PowerPlatformConnectors/tree/dev/independent-publisher-connectors/LibreBor
• Connectors - Welcome to the Independent Publisher Connector Directory! | https://github.com/microsoft/PowerPlatformConnectors/tree/dev/independent-publisher-connectors
• Call – Power Platform Integration LABs call – last Wednesday of each month at 11am ET/8:00 am PT. Join call at – aka.ms/PowerPlatformintegrationLABs
Learn more:
• Learn more about the Microsoft 365 Patterns and Practices community at: http://aka.ms/m365pnp
• Visit the Microsoft 365 Patterns and Practices community YouTube channel: https://aka.ms/m365pnp-videos
A
B
Thank
you,
mario,
so
very
quickly.
Liverpool
is
essentially
open
source
project
that
a
student
started
a
while
back
to
make
the
company
data
available
in
a
nice
computer
friendly
format
to
so
you
could
search
for
companies
and
directors
of
those
companies.
This
is
obviously
focusing
in
spain
is
building
spain,
where
at
the
moment
the
government
doesn't
have
an
api
for
this
type
of
data.
B
They
only
publish
it
on
pdf
format
and
the
the
founder
of
this
project
essentially
built
a
program
that
scans
the
pdf
files
extracts
the
information
stores
them
on
a
json
and
makes
it
available
in
this
nice
search
engine
that
you
have
here.
So,
for
example,
if
I
search
for
the
microsoft
company
in
spain,
you
can
see
the
all
the
details
and
all
the
stuff
now.
B
This
is
great,
because
there
is
not
that
much
that
many
sources
of
information
for
free
with
all
the
companies
data,
and
we
noticed
that
there
was
an
api
to
to
available
for
this
for
this
service.
So
we
approached
the
founder
of
this
project
to
see
if
we
could
create
a
connector
for
power
platform
on
on
to
to
use
this
data
on
power,
apps,
etc
and
even
in
dynamics
and
other
downstream
applications,
because
it
really
has
lots
of
value
to
allow
you
to
validate
id
numbers
of
companies
addresses,
etc.
B
A
Yeah
yeah,
no
definitely
so
while
marco
was
was
telling
you
about
the
story
of
liverpool.
What
I
was
doing
is,
I
was
showing
you
a
little
bit
the
website,
the
libreboard
website,
and
this
is
effectively
the
information
that
we're
going
to
be
able
to
retrieve
via
our
connector,
and
there
are
a
lot
of
things
that
I'll
show
you
down
the
line,
but
effectively
all
the
information.
All
the
information
that
the
register
of
the
spanish
register
has
for
a
company,
so
very
simple
scenario,
accounts
and
contacts.
A
We
have
an
application,
the
onboarding
process
of
a
new
of
a
new
company,
and
we
want
to
know
as
much
information
as
possible
from
the
spanish
register.
In
this
case,
I'm
going
to
go
ahead
and
I'm
going
to
create
an
account,
the
account
I'm
going
to
just
give
it
the
name
and
with
that,
what
we're
going
to
do
is
we're
going
to
launch
a
search
to
libreboard
in
order
to
be
able
to
retrieve
the
data.
A
A
But
now,
let's
hope
that
I
have
created
the
demogods
and
that
everything
is
gonna
be
fine.
Everything
is
gonna,
is
gonna
work,
I'm
sure
of
that,
but
we
just
now
trigger
the
flow
and
it's
gonna
go
to
the
api
from
liverboard
and
it's
gonna
come
back
with
the
information
that
it
does.
There
you
go
so
we
do
have
the
account
name,
so
it
has
found
the
account
and
it
has
updated
the
account
name.
It
has
also
provided
the
nif.
The
nif
is
the
national
id
of
that
specific
company
within
the
registry.
A
We
then
got
the
purpose,
and
I
know
I
should
have
made
that
field
a
bit
bigger,
but
we
also
have
the
purpose,
also
the
capital,
how
much
money
that
that
company
is
saying
that
it
has,
of
course
the
address
and,
more
importantly,
it's
bringing
us
the
active
members.
So,
who
are
the
active
partners
of
that
company
as
they
are
on
the
register
now?
A
Another
thing
that
we
might
want
to
do
with
a
new
with
a
new
with
with
a
new
account
is
that
in
this
case
we
have
retrieved
the
nif
the
number
directly
from
liberbot,
but
we
might
have
that
information
already
and
actually,
as
part
of
this
onboarding
process,
what
we
might
have
is.
We
might
need
to
validate
that
so
for
that
we
also
have
an
option
in
our
connector
that
it
allows
you
to
validate
that
the
national
that
the
dni
or
the
the
the
national
id
is
basically
correct.
A
So
I'm
going
to
go
ahead
and
click
on
that,
and
then
we're
going
to
validate
this
number
that
we
got
over
here,
which,
in
this
case
is
going
to
be
perfect
because
we
just
retrieved
it.
So
it's
fine,
but
then
once
they
trigger
that,
then
it
will
allow
me
to
go
ahead,
and
now
we
got
the
account
validated
and
then
move
on
on
to
the
business
process
flow,
and
it
should
have
also
triggered
a
notification.
Okay.
How
did
I
do
all
this?
A
Well,
very
simple:
let's
have
a
look
at
the
first
one
which
is
retrieve
company
details
and
then
I'll
show
you
how
the
connector
works
in
here
I
can,
then
I
choose.
Obviously,
whenever
it's
selected
I'll
make
it
bigger,
then
I
can
search
for
a
search
for
a
company
just
using
the
account
name
and
what
what
I'm
doing
here
is.
Basically
I'm
searching
the
company,
which
is
in
the
name
in
order
to
retrieve
the
slack.
The
slack
is
basically
the
the
hardcover
code
that
I'm
going
to
use
in
order
to
retrieve
all
the
other
information.
A
I
could
have
retrieved
all
the
other
information
by
name,
but
it's
a
bit
more
tricky.
So
I
get
the
I
get
the
company
name
and
then
what
I
do
is
I
get
the
company
information
by
slack.
Once
I
have
all
this
information,
then
I
go
ahead
and
update
the
rows
I
update.
You
know
I
put
the
information
that
I
just
show
you
and
then
I
look
through
all
the
active
positions
in
order
to
create
the
contacts.
Very
simple,
really
really
easy.
A
Let
me
show
you
some
of
the
other
actions
that
we
have
on
liverpool
before
I
jump
into
the
dni
validation,
but
over
here
you
can
see
that
we
can
find
company
information
by
the
slack,
which
is
the
one
that
are
used
by
nif,
which
is
the
nasdid
number
of
that
specific
company.
We
can
also
search
for
person
information
of
that
specif
of
we
also
get
personal
information.
A
So,
for
example,
if
we
search
for
amanda
ortega,
who
is
the
owner
of
inditex
or
sarah
and
massimo
dutti,
you
know
we
can
get
the
information
of
the
person
and
which
companies
is
owner
of,
and
the
other
thing
is
to
validate
the
nif,
which
I'm
going
to
show
you
in
a
second.
So
in
order
to
validate
that
number,
then
it's
as
simple
as
just
providing
the
number
and
it
will
come
back
whether
it's
a
valid
one
or
invalid
one.
What
is
how
is
that
validation
happening?
A
You
might
be
thinking
why
you
didn't
use
a
redex
expression
and
that's
it
well.
What
we're
doing
is
actually
going
to
the
register
and
validating
that.
The
nif
that
we
have
in
the
register
is
the
one
that
is
correct,
so
it's
not
only
a
validation
in
terms
of
it
has
x
numbers
or
it
has
one
letter.
It
actually
goes
to
the
register
and
brings
back
that
information,
and
with
that
said,
this
is
the
end
of
the
demo.
B
Yeah
there
is
a
bit
of
complexity
behind
that
and
some
economic
interests
of
the
company's
registry.
Well,
yes,
it's
true,
and
they
I
don't
know
if
mario
can
show
out
quickly
the
connector
definition
there,
but
the
the
the
president,
the
process
of
building
the
the
connector.
It's
really
really
simple,
once
you
have
a
bit
of
information
about
the
api
and
how
you
define
the
the
swagger
etc,
you
can
just
follow
the
the
assistance
here
and
test
it
validate
validated.
B
It
doesn't
really
require
development
knowledge,
it
helps
or
you
you
can
also
add
some
custom
code
and
stuff.
But
but
it's
really
a
case
of
understanding.
A
little
bit
of
the
api
definition
is
super
powerful
and
you
know
really
really
a
nice
way
of
bringing
interconnectivity
to
to
all
the
power
platform
and
by
stations
you
know,
power,
automate
and
all
the
logic.
A
Apps
as
well,
the
other
thing
that
I
want
to
say
is
a
big
shout
out
to
natalie
and
the
team
behind
the
independent
publisher
connector,
because
the
moment
that
you
finish
with
your
connector,
you
basically
upload
it
to
github,
and
then
you
receive
constant
feedback
on
a
daily
basis
of
how
your
connector
is
doing.
What
validations
are
doing
and
honestly,
the
process
is
so
simple
and
they
are
so
on
top
of
you
to
make
sure
that
you
understand.
Where
is
your
connector
in
the
journey?
A
D
Great
dumbo,
mario
marco,
but
let
me
try
sharing
my
screen
all
right,
so
there
are
currently
72
connectors
in
production,
but
you
know,
as
also
just
to
even
step
back
mario
and
marco
talked
about
this
little
right,
but
the
independent
publisher,
connector
program
allows
anyone
to
submit
a
connector
to
the
power
platform
right,
so
these
connectors
show
up
in
power
automate
power,
apps
and
azure
logic,
apps
and
soon
and
more
products
as
well.
So
we
have
37
outstanding
publishers
today
and
all
of
their
names
are
listed
on
the
right
side.
D
Here
we
also
wanted
to
give
an
update
that
there
is
something
called
the
power
platform
integration
labs
call.
So
this
is
learn,
ask
and
build,
and
we've
had
one
in
january
and
one
in
february
and
we're
going
to
have
our
next
one
at
the
end
of
this
month
and
essentially,
if
you
want
to
get
the
invite
feel
free
to
ping
me
twitter,
linkedin,
here
in
the
messages,
I
can
send
it
to
you,
but
that's
also
the
link
to
join
it's
just
a
k,
dot.
Ms
slash
power
platform,
integration
labs.
D
Essentially,
we
talk
about
all
integration
topics
within
the
power
platform,
whether
it's
you
know
how
to
build
a
trigger
for
a
connector,
how
to
use
code
for
a
connector
or
anything
to
do
with
data
flows.
Last
time
we
talked
about
best
practices
for
submitting
connector,
as
well
as
alm
upcoming
alm
features
for
custom
connectors
as
well.
So
it's
definitely
a
great
place
to
join
and
learn
on
what
the
product
team
is
working
on.
C
D
C
Awesome,
thank
you,
natalie,
mario
marco,
fantastic
stuff.
It's
great
to
see
also
that
you're
reaching
out
to
other
entities
in
the
community,
not
just
looking
and
if
they
don't
have
anything
or
an
open
api
you're,
not
just
simply
abandoning
it,
but
you're
actually
collaborating
with
them
to
be
able
to
create
these
connectors
so
really
great
job.
That's
very,
very
cool!
Thank
you.