Dynamics Community Forum Thread Details

Connector to retreive infomation from Dynamics GP

Hello everyone,

We have developped a data discovery solution. In order to implement it, we have first to get data subject to start the data discovery..

Data subject is basically a list of people (customer, employe, ex-employee, name, address...)

One of our client use Dynamics GP and Dynamics CRM both on prem.

We are using Azure data Factory to orchestrate the data pulling. Connectors already exists in ADF for Dynamics CRM but not for GP. I have been looking for any existing API/connectors but havent found anything.

Do you know if those connectors alredy exists? Any helpfull documentation to developp them on our side?

Otherwise we will just get the informations directly in their SQL server.

Thanks for your help,

Categories:

Microsoft Dynamics GP

Hi,

You can use eConnect APIs.

The following table shows the Microsoft Dynamics GP tables the Transaction Requester uses to retrieve data for the specified document type:

Install eConnect and go through the Transaction requester section. There is a sample project as well inside the eConnect folder.

Document type	Alias	Tables used
Cash_Receipt	Cash_Receipt	RM10201
Customer	Customer Address Internet_Address	RM00101 RM00102 SY01200
Customer_Balances	Customer Balance	RM00101 RM00103
Employee	Employee Address	UPR00100 UPR00102
GL_Accounts	GL_Accounts Details	GL00105 GL00100
GL_Hist_Trans	GL_Hist_Trans	GL30000
GL_Open_Trans	GL_Open_Trans	GL20000
GL_Work_Trans	GL_Work_Trans	GL10000
Item	Item Quantities	IV00101 IV00102
Item_ListPrice	Item ListPrice	IV00101 IV00105
ItemPriceLevels	ItemPriceLevels	IV00108
Payables_History_Transaction	PM_Hist_Trans Tax	PM30200 PM30700
Payables_Posted_Transaction	PM_Posted_Trans Tax	PM2000 PM10500
Payables_Transaction	PM_Trans Tax	PM1000 PM10500
PO_History_Transaction	PO_Hist_Trans Line Comment	POP30100 POP30110 POP10150
PO_Receiving_Hist_Trans	PO_Receiving_Hist Line Quantities	POP30300 POP30310 POP10500
PO_Receiving_Transaction	PO_Receiving Line Quantities	POP10300 POP10310 POP10500
Project_Acct_Contract	PA_Contract Cont_Bill_Cycle PA_Project	PA01101 PA02401 PA01201
Project_Acct_Contract_Template	PA_Contract_Temp Cont_Bill_Cycle_Temp	PA41501 PA42901
Project_Acct_Cost_Category	Cost_Category	PA01001
Project_Acct_Employee_Rate	PA_Employ_Rate Line	PA01402 PA01403
Project_Acct_EmployeeExpense	PA_EmpExp Line Tax	PA10500 PA10501 PA10502
Project_Acct_Equipment_Rate	PA_Equip_Rate Line	PA01406 PA01407
Project_Acct_MiscLog	PA_MiscLog Line	PA10200 PA10201
Project_Acct_Position_Rate	PA_Employ_Rate Line	PA01404 PA01405
Project_Acct_Project	PA_Project Bill_Cycle Budget Budget_IVItems Fee Fee_Schedule Access_List Equip_List	PA01201 PA61020 PA01301 PA01303 PA02101 PA05200 PA01408 PA01409
Project_Acct_Project_Access	Proj_Acct_List Employee_Detail Address	PA01408 UPR00100 UPR00102
Project_Acct_Project_Template	PA_Project_Temp Proj_Bill_Cycle_Temp Budget Budget_Items Fee Fee_Schedule Equip_List Access_List	PA41601 PA60020 PA40201 PA40202 PA60040 PA40203 PA41409 PA41401
Project_Acct_Timesheet	PA_Time Line	PA10000 PA10001
Purchase_Order_Transaction	Header Line Comment	POP10100 POP10110 POP10150
Receivables_Hist_Trans	Header Invoice_Tax	RM30101 RM30601
Receivables_Posted_Transaction	Header Invoice_Tax	RM20101 RM10601
Receivables_Transaction	Header Invoice_Tax	RM10301 RM10601
RM_SalesPerson	RM_SalesPerson	RM00301
Sales_History_Transaction	SO_Hist_Trans Line Line_Tax Commissions Distribution Payments Holds UserDefined Deposit Notes	SOP30200 SOP30300 SOP10105 SOP10101 SOP10102 SOP10103 SOP10104 SOP10106 SOP30201 SY03900
Sales_Transaction	SO_Trans Commissions Line LineTax Distribution Payments Holds UserDefined Deposit Notes	SOP10100 SOP10101 SOP10200 SOP10105 SOP10102 SOP10103 SOP10104 SOP10106 SOP30201 SY03900
UOFM	UOFM	IV40201
Vendor	Vendor Vendor_Addr	PM00200 PM00300
VendorItem	VendorItem	IV00103

Quick Links