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

Are there any solutions?


@xinguo wrote:

Thanks agemlex. Could you create another thread for this issue:

{
"error": {
"code": 500,
"message": "Expression value is invalid. The template field is required.",
"source": "europe-001.azure-apim.net",
"path": "choose[2]\\when[1]",
"clientRequestId": "72b11545-548e-4587-8ba8-2860-152495cd"
}
}

 

It looks like new issue from the gateway one. Could you also add the detail repo steps for this one at the new thread?


https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/Can-t-do-custom-connector-from-url/...

Hi agemlex,

 

We found a bug around Basic/Windows credentials with OData and are currently working on a fix.

 

Thank you for your patience, and for reporting the issue which led us to discover this issue.

 

-Alejandro

Thanks,
Alejandro

We are waiting for the fix Smiley Very Happy

Hi @alopezlago , is there any progress towards the solution? I recently ran into the same problem and for me, it is a show stopper I'm not able to integrate with NAV through the oData.

Hello, I am trying to get a custom page from Business Central to PowerApps through OData but I am also facing the same error regarding invalid credentials. Is it that even business central has the same problem as faced in navision regarding OData.

 

Yes, the fix should be rolled out sometime this week. Thank you for your patience.

Thanks,
Alejandro

Thanks @alopezlago,

Is there any other way I can get the custom table that I have created as an extension in Business Central. I tried using the Business Central connector and have also published the custom page of that table in Business Central as a Web Service but could not get it as the data source in PowerApps. Then I even tried by publishing the same page as an API but still the results are the same. So is it that there's no way or some other way all together to get the custom table as a data source that I have created in Business Central to PowerApps.

Hi @DhruvMehta, Business Central is not a supported connector for Power Query (which powers the CDS data import from PowerApps), so using the OData feed is probably the best route for you.

Hi @dazhang, Thanks for the information. So Business Central connector is not the viable option for now. But then the issue regarding the invalid credentials using OData by when will that be sorted out?

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

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 Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (2,902)