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
Everything Else
EndPoint Fun
 
Notifications
Clear all

Questions EndPoint Fun

 
Everything Else
Last Post by Tim Rodman 7 years ago
4 Posts
2 Users
0 Reactions
5,081 Views
RSS
mhoss
Posts: 34
 mhoss
Topic starter
November 19, 2018 7:38 pm
(@mhoss)
Trusted Member
Joined: 4 years ago

Hi All,
I'm having a bit of trouble with endpoints and the customer name. I'm hoping all of these issues are related and I'm just missing something.

1. If I extend the SalesOrder end point to include CusName - ( Mapped Object: Order Summary, Mapped Fields: Order Nbr. -> Customer Name)
And then if I run a get for the endpoint, it pulls out an array that includes all of the sales orders. I can filter based on any field, except the customer name. When I try to filter on the customer name - /SalesOrder?$filter=CusName%20eq%20%27NIH%27

I get this error - 

"message": "An error has occurred.",
"exceptionMessage": "Invalid column name '[SOOrder].[CuryPaymentTotal]'\r\nInvalid column name '[SOOrder].[PaymentTotal]'\r\nInvalid column name '[SOOrder].[CustomerID__BAccountR__acctCD]'\r\nInvalid column name '[SOOrder].[CustomerLocationID__Location__locationCD]'\r\nInvalid column name '[SOOrder].[ProjectID__PMProject__contractCD]'\r\nInvalid column name '[SOOrder].[DestinationSiteID__INSite__siteCD]'\r\nInvalid column name '[SOOrder].[Document_NoteText]'\r\n",

(the error goes on for awhile)

So... I tried making a new endpoint. To start, I made a GI that just shows a few SOs. But when I tried to extend the endpoint to the GI, I get this error when I get the endpoint . -

"message": "An error has occurred.",
"exceptionMessage": "Optimization cannot be performed.The following fields cause the error:\r\nCustomerID: View Results has BQL delegate\r\n",
"exceptionType": "PX.Api.ContractBased.OptimizedExport.CannotOptimizeException",

Any ideas on either of these? 
We have 10 mbs of sales data and I'm trying to only pull what I need.

Thanks,
Matt


3 Replies
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
November 21, 2018 11:39 pm
(@timrodman)
Famed Member
Joined: 10 years ago

Why not just use a Generic Inquiry with OData for this? Is there something that you need from the endpoint that the Generic Inquiry with OData doesn't offer?


Reply
mhoss
 mhoss
(@mhoss)
Joined: 4 years ago

Trusted Member
Posts: 34
November 22, 2018 12:48 pm
Reply toTim RodmanTim Rodman

Hey Tim,

I had forgotten about OData, that may be a good option. I’ll give it a go!

-Matt


Reply
Tim Rodman
Posts: 3193
 Tim Rodman
Admin
November 27, 2018 11:32 pm
(@timrodman)
Famed Member
Joined: 10 years ago

I'm using Generic Inquiries right now for an EDI project and it's going well.

The advantage is that you join to additional tables to get fields that are not included in the endpoint without having to customize the screen that the endpoint is based on.

The disadvantage is that the data is "flat" without the tree structure that the endpoint provides.

OData can be a bit wordy in what it returns. We're using the $format=json option outlined in this post to make the data easier to work with when it comes back:
https://www.augforums.com/augforums/acumatica-odata-with-microsoft-excel-and-power-bi/using-json-with-odata-in-acumatica/


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 10 Online
  • 2,338 Members
Our newest member: Shoaib Shafquat
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

  • Tim Rodman
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.

‹›×

    ‹›×