cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
agemlex
Helper II
Helper II

CDS OData integration. Invalid credentials

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 😞

37 REPLIES 37

@agemlex, from the traces on our end it appears that the gateway couldn't be accessed. Do other connections work through the gateway (for example, local files)?

Thanks.

 

Thanks,
Alejandro

Thank you! It could be firewall rules... Today is holiday in my country, tomorrow I change firewall rule. What ports I must accept on in and out for tcp or udp to-from Microsoft IP pool?

This page explains what ports need to be opened.

Thanks.

Thanks,
Alejandro

Good day,

 

I have accepted trafic on firewall. New one error appearance: Invalid credential. In Internet Explorer my ODATA URL works correctly (on same with gateway server). Screenshort in attachment.

Hi @agemlex: this error doesn't occur on our side, so it must be coming from the gateway. Could you get the logs from the gateway and send it to us (through private message or email)? We would be interested in the logs whose name starts with GatewayInfo.

You can find out how to get logs from the gateway by following these instructions.

Thanks,
Alejandro

private message was send.

I'v resolved the issure! The problem is in authentification in my internal system 1C. 1C can't get authorization data from GET request and this is why fail credention transmision. I switch off authorization and do firewall rule and On-Premises gateway connection for security. It works now! I get json throught flow Invoke an HTTP request and parse json after this.

@agemlex, thanks for the update, glad you were able to resolve the issue.

 


@agemlex wrote:

I'v resolved the issure! The problem is in authentification in my internal system 1C. 1C can't get authorization data from GET request and this is why fail credention transmision. I switch off authorization and do firewall rule and On-Premises gateway connection for security. It works now! I get json throught flow Invoke an HTTP request and parse json after this.


 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Users online (4,439)