D365 Financials web services no longer returning data

(0) Share

Report

Posted on by steveendow

2,281

I have previously tested the web service URLs on Dynamics 365 Financials, and they worked properly, returning JSON and XML data in Chrome. This video shows the web services working fine as of May 1.

https://www.youtube.com/watch?v=kmxar8kv_1o

On May 10th, I found that my D365 Financials account had been upgraded to version 16552, and I noticed that the web service URLs no longer worked on my account. I access the URLs, enter my username and web service access key, and I only get a blank page in my browser. No JSON or XML data is returned for any of the web service URLs.

I tried deleting and recreating a few of the web services and tried resetting my web service access key, but that didn't help.

I then tested with my partner demo account (MOD#######.onmicrosoft.com), and the web services work properly with that account.

So there appears to be an issue with the web services on my account.

Who can I contact to get assistance with this issue?

Categories:

Other

I have the same question (0)

All responses (13)

Answers (1)

steveendow 2,281 on at

Like (0)

Report

I just did several more tests and have some additional info. I tested the different web service URLs and here are my results:

ODataV4: Doesn't return any data

OData: Returns an error message

SOAP URL: Appears to work properly, returns XSD

Was this reply helpful? Yes No
Verified answer

Chris Bulson on at

Like (0)

Report

Hello Steve,

Check to see if you have a Web Service object "Allowed Companies". If you do, delete it and then test. I've had several instances where this Web Service has been added and it seems to break the rest. I'm not sure how it's getting added though as people keep telling me they are not manually adding it.

Thanks,

Chris

Was this reply helpful? Yes No
steveendow 2,281 on at

Like (0)

Report

Hi Chris,

Thank you very much for the response. I did have an "Allowed Companies" object and deleting it did make my OData web services start working immediately.

I definitely did not create that web service object--I don't even know what Allowed Companies means.

I see that my partner demo account does not have that web service object (and that account has always worked fine), so it seems to have been added to my account somehow.

Very interesting, thanks for all of the great responses on the forum.

Was this reply helpful? Yes No
Chris Bulson on at

Like (1)

Report

Hello,

I think we've figured out how it's getting added. If you go to 'My settings' and then click the arrow to expand the list of companies you can log into, it opens the 'Allowed Companies' window. If you click 'Edit in Excel' in this window it adds the Web Service. Whether people are doing this on purpose or not I don't know. Not sure why anyone would try to edit this list in Excel, but the option is there for people to click on purpose or by accident.

Thanks,

Chris

Was this reply helpful? Yes No
steveendow 2,281 on at

Like (1)

Report

Interesting. I just tried that and confirmed that it does create the Allowed Companies web service. I wouldn't be surprised if I clicked on Edit in Excel while poking around, so that would explain why it appeared on my account.

Was this reply helpful? Yes No
ckmscott on at

Like (0)

Report

Hi Chris - I've been getting a related error lately when trying to use PowerBI, which is "The feed's metadata document appears to be invalid.". I checked and had "allowed Companies" published as a web service. I deleted it and all the web services I added, then I watched Steve Endow's YouTube video to make sure I re-added all the web services necessary to connect with Power BI. My web services page looks exactly like Steve's, but still I'm having no luck connecting. Is there a list of all web services that must be present for Power Bi to connect to D365F?

Thanks,

Chris

Was this reply helpful? Yes No
Chris Bulson on at

Like (1)

Report

Hello,

There isn't a list. If you are matched up with what someone else has I would expect it to work. I would instead make sure the URL isn't getting messed up if you are copy\pasting it into Power BI. Paste the URL into notepad first and then re-copy it and paste it into Power BI.

Make sure you're following the guide here: blogs.msdn.microsoft.com/.../how-to-deploy-the-dynamics-365-for-financials-power-bi-content-pack

Thanks,

Chris

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hello Chris, in Dynamics365 we can use the excel add-in to change values and publish but as soon as we add new and try to publish we get "Data Object Not Provided Error"... we are getting this in all "Edit in Excel" interfaces. Ideas? Your help is greatly appreciated.

Was this reply helpful? Yes No
ckmscott on at

Like (0)

Report

Hi JohnsonX,

This error has to do with a field not being populated in the way Dynamics 365 expects. Sometimes a field may be missing or have an incorrect value. I have never had success with the Add New button. Have you tried just adding rows to the worksheet without clicking "Add New"? I added some General Journals that way, but it took me hours of trial and error to get it to work.

Just know that publishing in Edit in Excel is "iffy". There are some Edit in Excel sheets, that have publishing enabled, that I could not get to work at all. The situation seems to be getting better with each update, so I am

Was this reply helpful? Yes No
Chris Bulson on at

Like (0)

Report

Hey,

The publish in Excel issue is being caused by having Date columns added. You need to go into the Design area and remove any date fields form the workbook, then update, then you'll be able to publish new records back into Financials.

Depending one what area you are using the 'Edit in Excel' feature, you may need to remove multiple date fields.

This issue should be resolved in the next update I believe.

'Steps for fixing this when attempting to publish new Accounts'

• Open the Edit in Excel spreadsheet

• Click on ‘Design’

• Click ‘Edit’ next to G_L_Account_Card Table

• Under the Selected Fields area, Remove the ‘Last_Date_Modified’ field

• Click Update and then Done

• Click Refresh

Thanks,

Chris

Was this reply helpful? Yes No