Hello community,
I have been trying to use a GET method to login to my Acumatica instance using Postman, but it displays 404 error or sometimes 401 unauthorized error.
i have created a user account and have given the account as Admin & Access to OData roles. I have been using the following syntax in the postman:
https://siteURL/AcumaticaERP/OData
Is this the correct syntax that I have been using? If yes then why I am facing the issue?
Thanks in advance.
Hi
To configure basic authorization in Postman and test it, do the following:
1.In Postman, create a new collection and, on the Authorization tab, configure its authorization settings as follows:
a. In the Type box, select the Basic Auth type.
b. In the Username and Password boxes, type the username and password that you are using to access the Acumatica ERP instance for the training course.
c. Click Save.
2. In the collection, add a GET request to the following URL to retrieve the list of generic inquiries exposed through OData.
http://localhost/MyStoreInstance/OData/$metadata
3.Send the request
Is ODATA only used to retrieve the data from Generic Inquiries?
+11Hi
To configure basic authorization in Postman and test it, do the following:
1.In Postman, create a new collection and, on the Authorization tab, configure its authorization settings as follows:
a. In the Type box, select the Basic Auth type.
b. In the Username and Password boxes, type the username and password that you are using to access the Acumatica ERP instance for the training course.
c. Click Save.
2. In the collection, add a GET request to the following URL to retrieve the list of generic inquiries exposed through OData.
Url : siteURL/AcumaticaERP/OData/$metadata
3. Send the request.
+11Hi
Hi
So can we apply CRUD operations using ODATA?
+11Hi
So can we apply CRUD operations using ODATA?
OData is primarily used for data retrieval purposes
Hi
To configure basic authorization in Postman and test it, do the following:
1.In Postman, create a new collection and, on the Authorization tab, configure its authorization settings as follows:
a. In the Type box, select the Basic Auth type.
b. In the Username and Password boxes, type the username and password that you are using to access the Acumatica ERP instance for the training course.
c. Click Save.
2. In the collection, add a GET request to the following URL to retrieve the list of generic inquiries exposed through OData.
Url : siteURL/AcumaticaERP/OData/$metadata
3. Send the request.
What is the purpose of $metadata?
So if i have a dac of APInvoice then my syntax would be siteURL/AcumaticaERP/OData/APInvoice ?
+11Hi
To configure basic authorization in Postman and test it, do the following:
1.In Postman, create a new collection and, on the Authorization tab, configure its authorization settings as follows:
a. In the Type box, select the Basic Auth type.
b. In the Username and Password boxes, type the username and password that you are using to access the Acumatica ERP instance for the training course.
c. Click Save.
2. In the collection, add a GET request to the following URL to retrieve the list of generic inquiries exposed through OData.
Url : siteURL/AcumaticaERP/OData/$metadata
3. Send the request.
What is the purpose of $metadata?
So if i have a dac of APInvoice then my syntax would be siteURL/AcumaticaERP/OData/APInvoice ?
You should use like below,
siteURL/AcumaticaERP/ODatav4/PX_Objects_AP_APInvoice
Hi
To configure basic authorization in Postman and test it, do the following:
1.In Postman, create a new collection and, on the Authorization tab, configure its authorization settings as follows:
a. In the Type box, select the Basic Auth type.
b. In the Username and Password boxes, type the username and password that you are using to access the Acumatica ERP instance for the training course.
c. Click Save.
2. In the collection, add a GET request to the following URL to retrieve the list of generic inquiries exposed through OData.
Url : siteURL/AcumaticaERP/OData/$metadata
3. Send the request.
What is the purpose of $metadata?
So if i have a dac of APInvoice then my syntax would be siteURL/AcumaticaERP/OData/APInvoice ?
You should use like below,
siteURL/AcumaticaERP/ODatav4/PX_Objects_AP_APInvoice
Hey
+11HI
I hope you given username and password for the instance and tried to get the DAC information.
Does anyone know specifically what the 2025 R2 syntax will be?
<Acumatica ERP instance URL>/t/<TenantName>/api/odata/gi
Does TenantName need to be inbetween < > ?
Does the GI at the end mean “GI” or do we have to add the GI number?
/t/ is it really just /t/ or does the “t” stand for something else?
Getting closer to understanding it.
https://help.acumatica.com/Wiki/(W(1))/Show.aspx?pageid=7e92b45b-3610-4498-9898-24110bfccae3
The URL for the generic inquiry–based OData interface is <Acumatica ERP instance URL>/t/<TenantName>/api/odata/gi.
For example, a technical specialist would specify the http://sweetlife.com/erp/t/U100/api/odata/gi/$metadata URL if the following are true:
For SASS users in excel starting 2024R2:
If simply pulling GI data into excel, you can start with the syntax below. Use basic authentication and enter your Acumatica username and password. Excel then pulls up all exposed GI’s for you to choose from.
http://sweetlife.com/erp/t/U100/api/odata/gi/
You can also specify the GI you want like this and skip the list:
http://sweetlife.com/erp/t/U100/api/odata/gi/ExampleGIName
You can also input a filter on a specific GI. I’m still testing to see if the filter is done server side or within Power Query.
http://sweetlife.com/erp/t/U100/api/odata/gi/ExampleGIName?$filter=SalesPersonId eq 'CLACO'
In past versions I had to put %20 if there was a space in the tenant name or the GI name. Example: ABC XYZ had to be written ABC%20XYZ. It will take spaces now.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
