Adding an Acumatica Connector

Published: Sep 01, 2023

Adding an Acumatica Connector

Published: Sep 01, 2023

The following are the steps required to connect to your Acumatica.  This will allow you to pull data from your Acumatica account and custom build your lists in Popdock.

In order to install Acumatica you will need:

  • Client Id
  • Client Secret
  • Company (Tenant) Name
  • Endpoint Name
  • Endpoint Version

1. Sign in to your Acumatica site. If you have multiple tenants, sign in using the tenant you would like to install a connector for.  

After you sign in, navigate to Connected Applications by selecting Integration in the left navigation pane. You may need to select Show Full Menu to expand and see all the menu options. This is where you will see Connected Applications.

6307d9d470b36106d3758dbd acumatica connected applications 1024x664 1

2. On the Connected Applications screen, it will be defaulted to a blank form.  To create a new connected application, enter a Client Name

For the OAuth 2.0 Flow select Authorization Code from the dropdown list.

6307d9d470b3611bff758dbf acumatica connected applications 1 1024x664 1

3. Select ADD SHARED SECRET. On the Add Shared Secret window you will need to provide a description and then give the secret and expiration date. In the example below, the description is “Popdock Secret” and the expiration date to the end of 2021. 

Now you can copy the secret code from the Value field and paste it to the Client secret field for the connector setup. Then select OK to go back to the Connected Applications page.

Screenshot 2024 05 28 102553 censored

4. Setup the Redirect URIs by selecting the REDIRECT URIS tab.  Select the “+” button and enter the following URL:

https://eoneconnectorauth.azurewebsites.net/callback
6307d9d470b3610bc7758dc1 acumatica redirect 1024x384 1

5. Now that everything is configured for the connected application for Popdock, select the Save icon. This saves the configured connected application and generates a Client ID.  You can now copy the Client ID and paste it to the Client ID field in your connector settings. 

If your Acumatica system has multiple tenants the Client ID will end with “@Company” where “Company” is the tenant you were logged in with when you created the connected application client. Copy the entire Client ID including the @Company. In your connector setup, you will need to enter in the same company in the Popdock install screen as you have created the Client ID for, or the install will fail.

Screenshot 2024 05 28 102658 censored

6. The last item needed is the Endpoint name and version. Navigate to Web Services. Select Integration on the left navigation menu, and then select Web Services Endpoints.

6307d9d470b3611e72758dc2 acumatica web services 1024x664 1

7. From the Web Service Endpoints page you will see the Endpoint Name and Endpoint Version that is needed for the connector setup in Popdock.  Enter the Endpoint name and version in the format example showing on the field.  In the following example it would be:

Default/17.200.001

6307d9d470b3615beb758dc0 acumatica endpoint 1024x664 1

See the Acumatica documentation for how to edit the Endpoint to add new entities, fields, actions, or create custom endpoints.  If you change an endpoint you will need to refresh or reinstall the Acumatica connector before the changes take effect.

It is possible that changes to an endpoint could break an existing connector if you fail to refresh the connector after changing an endpoint in Service Endpoints that is being used by Popdock.

8. Next you will need to expose an inquiry or multiple inquiries to Popdock. Select Customization on the left navigation, then select Generic Inquiry.

6307d9d470b3615456758dc4 acumatica customization 1024x664 1

9. Now you should be on the Generic Inquiry page.  Here you can locate an inquiry by typing it in the Inquiry Title or click the magnify glass to see the full list.

6307d9d470b361120c758dc5 acumatica generic inquiry 1024x664 1

10. Select the Inquiry title that you want to expose to Popdock, then select SELECT.

6307d9d470b36145c0758bb4 acumatica select inquiry

11. Now that you have loaded the inquiry to the Generic Inquiry page, you can select the checkbox that next to Expose via Odata.  Then select Save.

You can also add individual entities to OData from their page.  When on a page, for example, Vendors that contains the Customization button in the upper right-hand side of the screen, you can select Customization, from the Customization menu select Edit Generic Inquiry. Then from the Generic Inquiry screen select the checkbox Expose via OData and then select the save button.

6307d9d470b361b350758dbe acumatica expose to Odata2 1024x664 1

12. Now that you have configured your Acumatica account for Popdock, you can add your connector simply by going to Connectors and selecting Add new connector.  Then complete the required fields and then select Validate on the left navigation menu.

image 10

13. Acumatica will ask if you want to grant Popdock access to your Web Services API, which is required, and/or Offline Access.  Select Yes, Allow to grant the permissions and complete your Acumatica setup.

6307d9d470b3617b91758b2e acumatica permission

14. After Popdock validates the connector settings with Acumatica, you will return to the connector setup page. The left navigation pane will show Connect.  Select Connect to add your Acumatica connector.

Screenshot 2024 05 28 102839 censored

15. Acumatica will ask again if you want to grant Popdock access to your Web Services API, which is required, and/or Offline Access.  Select Yes, Allow to grant the permissions and complete your Acumatica setup.

6307d9d470b3617b91758b2e acumatica permission

16. Acumatica will show in your Connectors list with a status of adding lists.  Once it completes you are ready to add a new tab and test out your new Acumatica connector.

6307d9d470b361833c758dc7 acumatica add lists status 1024x127 1

Need further help with adding your Acumatica Connector? Email support@eonesolutions.com

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

Reset Filters