Is It Possible Import Data to SugarCRM via Sugar Web Logic Hooks?

Hi everyone.

I just would like to inquire if anyone knows if it is possible to import data to SugarCRM via Sugar Web Logic Hooks?

For example:
WooCommerce to SugarCRM

If not, is there any alternative available (aside from Zapier)

Parents
  • The short answer is yes.

    Though there may be some limitations on the Cloud version of Sugar that I am not aware of since my implementation is fully on-site, as are most of our integrations.

    Sugar provides many APIs out of the box.

    Go to:

    https://<your sugar instance>/rest/v11/help

    to get a list of available APIs

    https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_10.0/Cookbook/Web_Services/REST_API/

    You can Pull data into Sugar, a Scheduler on Sugar that would run an API on the other system to retrieve the data and crate the records; or you can Push data from your other application to Sugar, having the other system call a SugarAPI to create records. I like to Pull rather than Push, I feel that it gives me more control.

    How you do it depends very much on your particular scenario.

    In both cases you will need to be very careful about how you do it, checking for duplicates for example, and making sure you are not inserting invalid values (check dropdown values to make sure they exist in your application's list strings for example) .
    You will also need to add some checks and balances so you know which records have been synced and which still need to sync, timestamps are not enough as syncs can and will fail, for whatever reason, especially if sending information to/from remote locations....

    If all that sounds scary, I am sure there are third-party options out there to make your life a little easier, but your question was specifically about Web Hooks and personally, I like to build my own solutions. Slight smile

    Hope this gets you a little closer to a solution you like.

    FrancescaS

  • Thanks for the feedback. Sadly I don't have the technical capabilities to work on the APIs, I was hoping there was a frontend solution that can be configured to POST and GET data :( 

    Oh, well.

  • Sorry for the delay with the answer - I was asking about an example not because of curiosity.

    To configure this with no coding skills, there is a way to use LB Databridge web service as the data broker, which could be deployed on-premise - it listens to the webhooks and when the webhook appears, it calls the custom processing logic preconfigured in Logic Builder - for processing data received and populating it through Sugar custom and regular modules.
    Again - no coding skills necessary.
    I will show here an example of catching and processing webhook so that you could evaluate whether it could work for your task , please, bear with me

    Best Regards,
    Dmytro Chupylka

    integroscrm.com
    We make work in Sugar CRM system faster, more convenient and efficient

  • No worries. I appreciate all the help given to me :) Thank you

Reply Children
  • Hi Jean,

    sorry for delay

    So LB Data Bridge is a middleware and one of its possibilities is to receive any webhooks and establish processing them in Sugar.
    Therefore, you can simply set LB Data Bridge Catcher as a URL a webhook in WooCommerce (or another system), and then configure how Sugar should process an event sent by WooCommerce.

    Here is an example – I do not have WooCommerce, but here is an example of processing of a subscription to e.g. HubSpot webhooks

    1. Subscribe to webhooks
      Usually, it’s performed via  UI of a system (HubSpot in my example)
      I created a subscription to 'Deal.Create' Event and set Target URL as LB Data Bridge:



    2. Each time, when the event occurs – the Deal is Created in the HubSpot - data is sent to LB Data Bridge which, in turn, sends it over to the Sugar's in special Module LB Data Bridge Queue.
      Here is an example of such a queue:

     

     

    And let’s take a closer look at the data received with a webhook:

      

    There is a received data in the InboundData field, - from the HubSpot it comes in JSON notation, but it could be any other format.

    Logic Builder allows to configure parsing of received data and Sugar's reaction on that data - create records, populate data through Sugar, perform calculations, ect.

    E.g. this logic creates Opp from the Hubspot data received with the webhook (there is only HubspotID in it):


    And here is a small video on how this approach works:

    download video (use full screen)

    When Opp is created with webhook processing, you may configure pulling more data from an external system via LB Data Bridge, e.g. to get Opp details from the Hubspot and enrich data of brand new Opp created  - also could be configured without a line of a code with Logic Builder.

    Therefore, if you have an example of a webhook to subscribe to in WooCommerce, we could try to apply this approach.

    Best Regards,
    Dmytro Chupylka

    integroscrm.com
    We make work in Sugar CRM system faster, more convenient and efficient