Re: IBM i as datasource for MS PowerApps

Hi Rob, All,

<vendor_message>

Everyone who is interested in introducing RPGLE based web services,
please take a look on our new product at www.i2rest.com. Our i2Rest is
not just another attempt to reinvent the IWS, in our native IBM i
client and server we add the support of common OAuth2 flows. In our
knowledge base you can find various examples of using i2Rest Client
and Server. We will try to work out the case with PowerApps and place
it on our case book soon.

While we are at the beta testing stage, everyone can try the fully
functional version of the product for free. I will be glad to answer
any questions

</vendor_messsage>

Regards,
Alexei Baranov

-------- Original Message --------
Subject : IBM i as datasource for MS PowerApps
From : Robert Rogerson rogersonra@xxxxxxxxx
To : Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Cc :
Date : 8 July 2020. 15:13

Hi All, I came across a discussion last night about retrieving data from
the IBM i using PowerApps.

I've been able to access data from a table by creating a custom connector
directly to the table and have also been able to access the data through a
custom connector to a REST API on the IBM i.
But both have issues.

When connecting to a table the problem is that all tables (tables not
indexes/logicals) in all libraries are shown for selection. This list is
sorted by library name so there may be hundreds of tables before I get to
the tables I'm looking for (if I even get to it). After hundreds of tables
are shown the last entry allows you to enter a library and table name.
Does anyone know how to limit/filter this list to just certain libraries or
tables? Should I be seeing indexes?

As for the REST API approach. I have created four crud apis for a table.
(GET, POST, PUT, DELETE) I have tested all four using Postman with
success. But when I try to create a custom connector in PowerApps, on the
test tab only the GET works. The tests fail for POST, PUT and DELETE.

I have been posting on the PowerApps forums for weeks and getting no
response.
Has anyone in the IBM i community had any success they can share?

I see that Arco Simonse, Matt Olson, Nathan Andelin, Richard Schoen and
Jack Woehr were active in this thread back in August 2018. I'm wondering
if they have anything to add.

Thanks for any help or suggestions.

Rob