AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica OData wit...
OData POST request ...
 
Notifications
Clear all

Questions OData POST request returns 404 Not Found; error message: "No routing convention was found to select an action for the OData path with template '~/entityset'.

 
Acumatica OData with Microsoft Excel and Power BI
Last Post by Tim Rodman 6 years ago
5 Posts
3 Users
0 Reactions
4,922 Views
RSS
Posts: 2
 Sabrina Rojba
Topic starter
January 20, 2020 9:44 am
(@sabrina-rojba)
Member
Joined: 6 years ago

Hello, 

Having this schema: 

<service xmlns=" http://www.w3.org/2007/app " xmlns:atom=" http://www.w3.org/2005/Atom " xml:base=" https://tryisv.acumatica.com/odata/CData/ ">
<workspace>
<atom:title type="text">Default</atom:title>
<collection href="BI-Customers">
<atom:title type="text">BI-Customers</atom:title>
</collection>
<collection href="BI-Employees">
<atom:title type="text">BI-Employees</atom:title>
</collection>
<collection href="BI-Opportunities">
<atom:title type="text">BI-Opportunities</atom:title>
</collection>
<collection href="SO_Shipment">
<atom:title type="text">SO_Shipment</atom:title>
</collection>
<collection href="CommissionData">
<atom:title type="text">CommissionData</atom:title>
</collection>
<collection href="CR-CampaignSalesOrders">
<atom:title type="text">CR-CampaignSalesOrders</atom:title>
</collection>
<collection href="DB-CashByPeriod">
<atom:title type="text">DB-CashByPeriod</atom:title>
</collection>
<collection href="BI-CreationDate">
<atom:title type="text">BI-CreationDate</atom:title>
</collection>
<collection href="AR-Customers">
<atom:title type="text">AR-Customers</atom:title>
</collection>
<collection href="BI-Dates">
<atom:title type="text">BI-Dates</atom:title>
</collection>
<collection href="CR-CampaignInvoices">
<atom:title type="text">CR-CampaignInvoices</atom:title>
</collection>
</workspace>
</service>
 
I am trying the following request to Acumatica OData endpoint: 
 

POST https://tryisv.acumatica.com/odata/CData/CommissionData HTTP/1.1
Host: tryisv.acumatica.com
Authorization: Basic ***
Accept-Encoding: gzip, deflate
User-Agent: CData Data Provider Engine - www.cdata.com - Accepts: gzip
Cookie: UserBranch=; LegacyUI=0; path=/; Locale=TimeZone=GMTE0000U&Culture=en-US
Content-Type: application/atom+xml
Content-Length: 528
MinDataServiceVersion: 3.0
accept: application/atom+xml,application/atomsvc+xml,application/xml
MaxDataServiceVersion: 3.0

<entry xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns="http://www.w3.org/2005/Atom">
<category scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" term="PX.Data.CommissionData" />
<content type="application/xml">
<m:properties>
<d:SalespersonID m:type="Edm.String">SP0002</d:SalespersonID>
<d:Customer m:type="Edm.String">CJOEQUIP</d:Customer>
</m:properties>
</content>
</entry>

I get a 404 Not Found status response with the following message: 
No HTTP resource was found that matches the request URI 'https://tryisv.acumatica.com/odata/CData/CommissionData'.

inner message: No routing convention was found to select an action for the OData path with template '~/entityset'.

Appreciate your help on this. 


4 Replies
programfred
Posts: 45
 programfred
January 21, 2020 10:25 pm
(@programfred)
Trusted Member
Joined: 5 years ago

 For the URL of the Acumatica ERP OData endpoint, use one of the following:

    • <InstanceURL>/OData/<TenantName>/, where <InstanceURL> is the URL of your Acumatica ERP instance and <TenantName> is the login name of the tenant in the Acumatica ERP instance for which you configured inquiries in a multitenant configuration.
You can find the login names of tenants on the Tenants (SM203530) form.

 

you probably need to check you tenants name.


Reply
Posts: 2
 Sabrina Rojba
Topic starter
January 22, 2020 9:35 am
(@sabrina-rojba)
Member
Joined: 6 years ago

GET and PATCH requests to the same url are successful. POST is the only one failing. 


Reply
programfred
Posts: 45
 programfred
January 27, 2020 7:39 pm
(@programfred)
Trusted Member
Joined: 5 years ago

Odata build on GI in different tables, it might not suppot post.

if you wanna update data within API,  probably look at web service.


Reply
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
February 8, 2020 8:28 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Agreed. OData only lets you read data.

Here's a note from an Acumatica Developer Webinar:

https://twitter.com/TimRodman/status/1204579987782799360


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 30 Online
  • 2,324 Members
Our newest member: Michael Kiley
Latest Post: Pick List report suddenly not splitting on Shipment
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×