Forum Discussion

Reso's avatar
Reso
6 years ago
Solved

Syncing MYOB EXO mailing list to Mailchimp

I'm wanting to sync MYOB EXO with Mailchimp so that when a customer is added in EXO they're also added to mailchimp,

 

I have some experience working with PHP so i'm considering making an app for it but never used the MYOB api before, does anyone have any experience who could give me a basic idea of how to achieve this?

 

Another way I thought of is to have EXO store its mail list on google drive, then link to that mail list in mailchimp, not sure how possible this is though as I've had limited access to the companies EXO software.

 

If anyone knows the best way to achieve this would really appreciate if you could post! 

  • Steve_Marriott's avatar
    Steve_Marriott
    6 years ago

    Hi Reso 

     

    That sounds about right to me.

     

    The App could reside anywhere you want as you will be calling the API which allows it to work from anywhere. If you wanted to write your App to run on the Windows Serever that Exo is running from then you could go direct to the SQL database to read the data from Exo, it possibly makes it easier as you will only have the mailchimp API to call. If you are writing back into Exo then I strongly suggest using the Exo API so its valid data being written back in.

     

    Hope that helps.

     

    Steve.

     

5 Replies

Replies have been turned off for this discussion
  • Steve_Marriott's avatar
    Steve_Marriott
    Valued User
    6 years ago

    Hi Reso 

     

    The Contact Details plus Customer Details are all held in the MS-SQL database in various tables, which means there is no "list" of contact details that are external and can be accessed. Most people create an APP that will sit in hte middle and sync bothways between the systems. You will need to look a teh Debtor Accounts as well as Contacts.

     

    Cheerts

     

    Steve

     

  • Steve_Marriott's avatar
    Steve_Marriott
    Valued User
    6 years ago

    Hi Reso 

     

    That sounds about right to me.

     

    The App could reside anywhere you want as you will be calling the API which allows it to work from anywhere. If you wanted to write your App to run on the Windows Serever that Exo is running from then you could go direct to the SQL database to read the data from Exo, it possibly makes it easier as you will only have the mailchimp API to call. If you are writing back into Exo then I strongly suggest using the Exo API so its valid data being written back in.

     

    Hope that helps.

     

    Steve.

     

  • Reso's avatar
    Reso
    6 years ago

    So there's no way to do this other than creating an APP?

     

    Also i've applied for the myob api but haven't heard back yet.

     

     

  • Reso's avatar
    Reso
    6 years ago

    Steve_Marriott Ah so the app itself is creating the list from the data tables and then that would then tie in the mailchimp api so that it exports that list into my mailchimp audience?

     

    As I currently understand it the app would function as follows:

     

    1. GET: {URI}/debtor (get all debtors)
    2. GET : data tables from each debtor (emails, names)
    3. Create List: List emails and names.
    4. GET: mailchimp audience web id
    5. Post list of names in audience "names" column
    6. Post list of emails in audience "emails" column

     

    I have the code that would allow me to input data into my mailchimp audience it's just about getting the data I need from MYOB.

     

    Would you say the next step would be to get access to the MYOB EXO API and then write the code I need to get the data tables I need, then tie in mailchimp so that it posts that data inside the correct audience and then finally paste that in MYOB EXO as the app?

     

    Is there a specific place you would paste the app in EXO?

     

     

     

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.