Conditional logic in rules?

Get Help
1

I assume the answer is, “Computer says no,” but I’m going to ask for advice anyway:

I want to do a regular import of a CSV from another source. If the key of a record (in this case, an email address) already exists in a database, the import needs to update the corresponding fields. If the key does not exist, it needs to add the record and update the corresponding fields.

My current setup is that I import the CSV into a temporary database and then use a Created rule on the temporary database that finds the existing records in the target database (and updates the field values). But I cannot seem to combine that with an insert if the record doesn’t exist.

Am I right that this isn’t supported? If not, I’ll have to rebuild everything in Make and I’ll have to pay for the transactions, I suppose. :frowning:

2

This is not ideal but why not have two rules in Fibery?
One that runs if the key is a duplicate and one that runs if it is not?

There is no conditional logic in automations and rules but there’s also nothing stopping you from having two automations with similar filters.

1 Like
3

I have good news for you, it is possible to solve this problem using a Fiberflow automation (and it’s completely free to do so). Here is the automation:

fiberflow-automation-upsert-fibery-contact

The automation performs the following steps:

  • The automation runs whenever a new entity is created inside the “Contacts Import” database, which is a temporary database that is used to import the CSV to.
  • Delay execution because we run into Fibery API rate-limits (will be fixed).
  • Search for an existing contact that has the same email as the imported contact.
  • Conditional Action:
    • If an existing contact has been found, update that one.
    • Otherwise, create a new contact with the same field values as the imported contact.

The automation supports Fibery batch creation such as the CSV import performs.

If you run into any problems, please let me know. I will fix the errors and ensure that you can perform the CSV import for your contacts :slight_smile: . You can sign in here: app.fiberflow.io.

Cheers,
Ben

4

Good idea, thanks! I will try that.

5

Good to know. Thanks!

6

I love the idea of Fiberflow and would love to have the functionalities provided but unfortunately cannot provide access to company data to a custom user made integration :confused:
That is basically what you have to do by sharing an API with another software, no?

1 Like
7

@Eren_Turgut thanks for the kind words. I get it, giving a random one-person business from Germany access to your company data requires some trust or might even be impossible due to company policies.

Unfortunately you are right, the only way I can offer the functionality of Fiberflow is by accessing your Fibery workspace via a User API Key or the “Log in with Fibery” OAuth access. Fibery currently does not support fine-grained access control, so the user has to give full access to the integration.

I will address this issue in the following ways:

  • Work with the Fibery team to make Fiberflow an officially endorsed integration.
  • Post feature requests asking for fine-grained integration permissions.
  • Become a Fibery partner.
  • Look into certifications like SOC 2 and find some that are less expensive to acquire.
  • Keep showing up for the Fibery community and be helpful :slight_smile:

In the meantime, if you want to support the project, you can create a new Fibery workspace with only demo data in it to test Fiberflow and maybe give some feedback! :green_heart:

Cheers,
Ben

2 Likes