Custom Connector to connect with Business Central

Note: If you don’t have any customization at business central then you can directly use the Data Source of Business Central, but if you have any customization in Business Central from scratch or extended fields then the Data Source of Business Central will not work for you. To access those custom fields and entities we need to create Custom Connector.

There are so many actions available in Custom Connector like Get, Delete, Post, Put, Head, Options and Patch. So, we are going to look at Get, Post, Patch and Delete.

How to Create Custom Connector?

Step 1: Click on Custom Connector in PowerApps, now, click on New Custom Connector and after that we need to Click on Create from Blank.

Step 2: Add the Name of your Custom Connector, You need to add multiple actions into the one Connector.

Step 3: Now Let’s Add Details in Custom Connector. We need to add Business Central Host in Custom Connector api.businesscentral.dynamics.com.

Step 4: Now move on the Security Tab and add User Name and Password after selecting the Authentication Type.

Now let’s move into the Definition tab

Get

Step 5: Let create Get action first to create get action we need to click on New Action Button as per below image. And need to add function name so it will be visible at PowerApp Side when we develop an app.

After adding the information we need to add the request information. In Request part need to click on the Import from sample.

Now, Click on the Get verb and When you add the URL at that time don’t forgot to add variable for Company Id without that  the solution will work as static. After adding all the information click on the Import Button.

Right now we are in the last step to complete the Get Action in which we need to add the default response from web service of business central.

Now you can test your custom connector from the last Test tab. But let’s do that later before that let’s complete the other actions.

 

Post

Same as the Get action we need to add name of the function and action in the General part.

After adding the information at General Tab we need to add the details into Request tab as below image. We need to select Post action and after that we need to add the URL and sample body which we are going to use in our PowerApps.

Now we need to do same thing into the response part.

Update

Update action will work the same way but for this action we need to add parameters (filters) because business central need if-match formula as well as the sample body and filters to identify which records need to modify. So, let’s start with General Tab. Same as the above two actions we need to add the function and action names into the General Tab.

Now, the main change is in the Request section what we need to do is need to add the filter so the business central web service will identify the records which are you going to modify.

Also the If-Match header is important without that patch call is not going to work. And same as post we need to add the body also into the response section as well.

Delete

We are not going to show all the parts in delete because it is working the same way as Patch just we need to add the all the details from Patch action just one difference between these two is for Body, Delete action will not have any Body.

This is all for Custom Connector now, any developer can use this Custom Connector for Get, Post, Patch and Delete.