• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Step of get Contact by Email from Zoho Books is throwing the same error on multiple automations

GSG

Member
Since Friday last week, a number of our automations which involve "get contact by email" from Zoho Books are throwing a Customer ID error.

In the testing phase, the 'get contact by email' step is working correctly and we use the result of this step for the next step (create a sales order in Zoho Books), using the 'contact ID ' that is returned by the 'get contact by email' step.

However, in the live automation, the correct contact ID is not being brought into the Sales Order. The same incorrect contact ID is being populated into every single sales order (it's always the same one, and it is the first contact alphabetically in Zoho Books 'Aaron Marshall').

To test this issue, we created a brand new automation from scratch, but the same error persists on the get contact by email step and thereafter creation of sales order step. I attach 4 screenshots showing this error. As this has affected all of our automations which involve get contact by email (which is about 30 of them), I don't want to make any changes until I have spoken to you about this error, why it might suddenly have started happening and what is needed to fix it.

All the automations affected were working well for several months until Friday last week. Now they are all failing for the reason stated above.
 

Attachments

  • 1. Testing Get Contact by Email works OK.png
    1. Testing Get Contact by Email works OK.png
    319.7 KB · Views: 5
  • 2. Testing - Create Sales Order works OK with correct Customer ID.png
    2. Testing - Create Sales Order works OK with correct Customer ID.png
    259 KB · Views: 4
  • 3. Live - Incorrect CUistomer ID is returned .png
    3. Live - Incorrect CUistomer ID is returned .png
    208.4 KB · Views: 4
  • 4.Incorrect customer ID is put into the Sales Order.png
    4.Incorrect customer ID is put into the Sales Order.png
    214.1 KB · Views: 5

Preeti Paryani

Moderator
Staff member
Pro Member
Hello @GSG,

The workflow has been set up correctly, and each step is functioning as expected. However, please note that, as indicated in the error message, the step failed because the customer is marked as inactive.

1746441355780.png


1746441365699.png


To avoid this issue, we recommend adding a Filter step to check and proceed only if the customer status is active. Please refer to the attached image for more details.

1746441380471.png
 

GSG

Member
I think you misunderstand.

The customer in this case (and all other cases) was not inactive. The issue is that in the live scenario, when the get contact by email step is processed, it always returns the same customer ID (Id number 2130347000001645448 - which is inactive but is the wrong customer ID - i.e this customer ID does not belong to the email address used in the collect Customer information step). We have thousands of customers in our database and so why is this rogue customer ID always returned every single time?

To reiterate, this is not the customer ID that is associated with the email address that was used in this step to collect the customer information. As I mentioned in my original post, this is happening with every single step in all automations involving get contact by email address. The solution you offered is irrelevant for my problem, as in all cases the customer for whom we are collecting data in the step is not inactive.

The issue I am asking you to look into is the "get contact by email address" process is now flawed / corrupted by something. Something changed at the end of last week and this step is no longer working as it is supposed to work . Please can you check the backend for this step as it may be that Zoho Books has updated something in their App which requires Pabbly to adjust / tweak the setup for this step.
 

GSG

Member
In a follow up to this thread,I notice that in the live version of the get contact by email step that 200 of the contacts in Zoho Books are being returned in the Pabbly response to the email address which belongs to one customer, whereas only one contact should be returned. The reason why the same ID number of 2130347000001645448 is returned is because this is the first name alphabetically in the entire customer list.
 

Resham

Moderator
Staff member
Hello,

Greetings!

We have added a step in your workflow to retrieve the correct email.

1746508429300.png


It seems to be working fine, please test and let me know if this works for you.
 
Top