Skip to main content
Solved

Create a new webservice endpoint for the Invoices and Memo GI


param2022
Jr Varsity II
Forum|alt.badge.img


For this GI AR3010PL, I am trying to create a new web service endpoint. I am able to fetch All records but I need to fetch the “Due Date”​ filtered data. Not sure how to achieve that.
 

 

Following is how i am sending request in postman

 

 

Best answer by RohitRattan88

@param2022 

I achieved to do this by exposing GI to oData and then using $filter as @Naveen Boga  suggested:

expose via oData
API Call on oData

Try this and see if it helps

View original
Did this topic help you find an answer to your question?

4 replies

Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3417 replies
  • June 20, 2023

Hi @param2022  As you wanted to fetch the invoices based on the Due Date filter, you need to use the $filter in the API request.

Below is the help document and hope this helps

 https://help-2021r2.acumatica.com/(W(2))/Help?ScreenId=ShowWiki&pageid=f279ec05-2f71-4376-a76f-d3ed0e0e2556


param2022
Jr Varsity II
Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 94 replies
  • June 20, 2023

Hi @Naveen Boga .

I tried that $filter thing for just simple text of description before using dates condition but it is giving me below error. 
 

"message": "An error has occurred.",
    "exceptionMessage": "The given key was not present in the dictionary.",
    "exceptionType": "System.Collections.Generic.KeyNotFoundException",

 


RohitRattan88
Acumatica Moderator
Forum|alt.badge.img+4
  • Acumatica Moderator
  • 253 replies
  • Answer
  • June 20, 2023

@param2022 

I achieved to do this by exposing GI to oData and then using $filter as @Naveen Boga  suggested:

expose via oData
API Call on oData

Try this and see if it helps


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3417 replies
  • June 20, 2023

Yes, we need to check the “Expose via OData” for the GI’s to fetch the data from Rest APIs.

Thanks for mentioning here @RohitRattan88 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings