New to the community? Start here

Airtable integration using Hustle API

0

Can you please add airtable integrantions?

Meanwhile I’m trying to send the data using API. I created a webhook URL so I can grab the info with an Integromat automation and send a new record to Airtable. When I check the webhook data, there are only email and GDPR fields.

How can I obtain the following fields: ID, IP address and date?

Thu, 7 May 2020 9:54:22
More Hustle Pro discussions
Hustle Pro
  • Adam
    • Support Gorilla

    Hi Giuseppe D.

    I hope you’re well today and thank you for getting in touch with us!

    As for Airtable integration – I’ve already asked our Hustle team to consider this and I’ll let you know once I got some feedback on it.

    As for the “webhook” and getting additional data, I’d like to ask you for additional information. I understand from the chat that you’re using “Integromat” service as a “middleman” to push data to Airtable but I’m not quite sure what exactly do you mean by the webook that you’re using and how are you actually using it with Hustle.

    There’s no “Integromat” integration either so are you using some custom code to achieve that – if so, could you tell me more about it or, if possible, even share such code? Or are you using e.g. Zappier to integrate Hustle with Integromat frist?

    Please elaborate a bit on how this all is set up as this will help me find out if there’s a solution and what would it be.

    Kind regards,
    Adam

  • Adam
    • Support Gorilla

    Hi Giuseppe D.

    First of all, let me apologize if I caused any confusion. I suppose you might have received my previous response (above) in an e-mail – I’ve edited and removed it as I made a mistake, working on a similar ticket at the same time. I’m sorry about that!

    If you didn’t get it, read on please. If you did, the solution would still be similar though :slight_smile: You’d want to start with adding two “Hidden” – type fields to your popup/embed/etc, in “Emails -> Opt-in Fields” section.

    Then edit these two fields and in one select “Date” as “Default Value” and in the other one select “User IP” as default value.

    Those fields would then be available in Zapier just like any other field so you can assign them to whatever you need.

    As for ID, that’s automatically generated by the database but I’m not sure if integration (webhook) is triggered before or after it’s done. If before – there’ll be no way to fetch it. If after, there might be some sort of “trick” or “hack” to do this but I’ll need help from our developers.

    I’ve already asked them for consultation and we’ll update you here as soon as we get to know more details on this.

    Best regards,
    Adam

    • Giode
      • Creative Enterpreneur

      Hey Adam, thank you for your solution. No problem, I’ve read your previous answer and I understand the logic behind so my problem was fixed!

      Waiting for some workarounds about the ID field so.

      Thank you again! :slight_smile:

  • Alessandro
    • Nightcrawler & Daydreamer

    Hello Giuseppe D.

    Your integrations are really nice! :tada: To help you further I developed a code snippet that adds entry_id to the requests so you can use it as you wish. Note: Existing entries (primary key: email) will keep their entry_id intact.

    You can download the snippet from here:
    https://gist.github.com/wpmudev-sls/94780d2536c15cfda81cf49ce5fc54e7

    Once downloaded, you can unzip it and upload the wpmudev-hustle-integrations-zapier-entry.php file to your site’s wp-content/mu-plugins directory.

    If you need more help on installing this custom plugin please read our detailed guide here:
    Installing WPMU DEV Plugins > Installing Mu-plugins

    I attach you some screenshots of Zapier and Google Sheets. :blush:

    Let us know if this worked for you. :nerd:

    Kind regards,
    Alessandro.