web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / How to connect/export ...
Microsoft Dynamics NAV (Archived)

How to connect/export data from NAV into Google products like Sheets or Calendar?

(0) ShareShare
ReportReport
Posted on by StanMST 14

Have any of you tackled any of these scenarios? I can't seem to find info on the interwebs about an available connector or way to do this out of NAV 2017. Essentially, I want:
- To feed a list of customers into a Google Sheet and/or update that sheet whenever a new customer is added or UPDATE is made in NAV.
- To get a list of customers who have something due on a specific date (custom table) and push that date with the customer info in a Google Calendar.

Any advice on this direction is appreciated! I had come across a framework from ArcherPoint for NAV 2009, but things have changed since then...

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Guillem Padilla Profile Picture
    Guillem Padilla 427 on at

    Hi,

    You have to use DotNet to make API requests

    In this case you can see how google sheets and calendar API works here: 

    https://developers.google.com/sheets/api/reference/rest/

    https://developers.google.com/calendar/v3/reference/

    See this documentation on how to call external APIs from Dynamics NAV:

    https://community.dynamics.com/nav/b/dynamicsnavcloudfronts/archive/2017/07/10/procedure-to-call-an-external-api-from-microsoft-dynamics-nav

    As you need to create JSON from NAV, I suggest you download Newtonsoft's JSON.net library if you do not have it already, since it allows you to use it within NAV as DotNet.

    I hope it helps

  • Suggested answer
    Jackson Young Profile Picture
    Jackson Young 20 on at

    I was on this forum a few months ago looking for a solution. The one mentioned here hasn't worked for me. But a connector called Automate.io did. This link should help you for sure - https://automate.io/integration/google-sheets/microsoft-dynamics

    You have to connect your Microsoft Dynamics account to your Google spreadsheet and map the data that you want to send to the sheet. I found it to be pretty easy to use. 

    For the Google Calendar scenario, this should help you - https://automate.io/integration/google-calendar/microsoft-dynamics

    Let me know if it worked for you guys.

  • Verified answer
    dvcoop Profile Picture
    dvcoop 30 on at

    Hi Stan, i'm doing something a little different than the usual api methods to do something very similar. The stack i'm using is Azure Data Factory, Azure SQL DB and PowerBI.

    I'm making direct sql queries into the NAV database to pull out the data I need (using the sql queries to modify/format the output in the format I need), and loading the output into a separate SQL database (in your case you would be loading it into google sheets) using Azure Data Factory. My Nav 2017 is hosting on an Azure server, so this makes the whole process pretty streamline.

    Even if you have a on prem hosted Nav you should still be able to use sql to extract the data you need and dump on the local server and then transfer the data to the google sheets.

    I have seen where Microsoft has some Azure connectors to Google Sheets, so you should be able to substitute Azure SQL DB and PowerBI with Google Sheets.

    We had started down the road of the web api, but was not finding that with Nav 2017 not all the data was exposed, so we made the decision to go right to the source. The only downside to this method is that Nav Data architecture is pretty convoluted.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans