Good day!
We have accounting system (1C https://1c.ru/eng/title.htm). It have posibility of OData integration (on web server Apachi). In test enviroment on PowerApps Plan2(Trial version), CDS, we try to get data from OData url throught local Gateway (we have tested it. It works for Sharepoint or files with our domain credential). After populate url and credential on next, we get error(it is translate from russian): Invalid credentials. (session ID: 929cc5aa-f99a-4688-bfb0-d3f92ba33996). Then we try do the same for odata.org example https://services.odata.org/V4/TripPinServiceRW without authorization, it work excellent.
Our data:
URL: http://localIP/buh_sharepoint/odata/standard.odata/Catalog_OS (Yes, it is works wrought IE on gateway server, after credential step).
Credential method: Basic or Windows
OData response: (1C public this like Odata format)
<?xml version="1.0" encoding="UTF-8"?><feed xmlns="http://www.w3.org/2005/Atom"
xmlns:at="http://purl.org/atompub/tombstones/1.0"
xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices"
xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"
xml:base="http://InternalIP/buh_sharepoint/odata/standard.odata/">
<entry>
<id>http://internal_ip/buh_sharepoint/odata/standard.odata/Catalog_OS(guid'eef7d89d-c3a9-11e4-80bd-2c44fd8868ab')</id>
<category term="StandardODATA.Catalog_OS"
scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme"/>
<title type="text"/>
<updated>2018-10-16T08:42:11</updated>
<author/>
<summary/>
<link rel="edit"
href="Catalog_OS(guid'eef7d89d-c3a9-11e4-80bd-2c44fd8868ab')"
title="edit-link"/>
<content type="application/xml"><m:properties xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
<d:Ref_Key>eef7d89d-c3a9-11e4-80bd-2c44fd8868ab</d:Ref_Key>
<d:DataVersion>AAAAAAAAB9E=</d:DataVersion>
<d:DeletionMark>false</d:DeletionMark>
<d:Code>ОФ001642 </d:Code>
<d:Description>Принтер матричный Epson L</d:Description>
<d:Name>Принтер матричный Epson LX-350 </d:Name>
<d:MOL>Ли Андрей Леонидович0000000000</d:MOL>
<d:CodeDoc>ОФ001642 </d:CodeDoc>
<d:INV_Number>ОФ001642 </d:INV_Number>
<d:Price>36089.29</d:Price>
<d:Date_Uchet>0001-01-01T00:00:00</d:Date_Uchet>
</m:properties>
</content>
</entry>
.... next 2200 pices of entry
</feed>
How can I integrate PowerApps or Azure with my accounting system throught local gateway.
P.S. Accounting system have MS SQL DB, and yes I can connect to it, throught local gateway, but on load data step I have other error - "a" it is not a function 😞
