AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register

— The Forums are now read-only —

— All new activity now takes place here: —

AugForums.com Discord Server
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
5,701 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: 6 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: 6 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: 3204
 Tim Rodman
Admin
February 8, 2020 8:28 pm
(@timrodman)
Famed Member
Joined: 11 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,533 Topics
  • 11 K Posts
  • 14 Online
  • 2,437 Members
Our newest member: Matt Butler
Latest Post: Nested SubReport Issue
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

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

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

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

‹›×

    ‹›×