I want to integrate zoho books with my database which is in MySQL. I tried using zapier. First suggest me that i’m thinking in a right way or not. My approach is I created a function in my database which will create an item in my DB and I also added a trigger in zap for the same table and i configured an action for zoho books to create an item. When i’m inserting a new row into my table then the error ocurrs that SKU is not returned. I understand the zoho book items require a new SKU for each item. I’m stuck at how i’ll create a new SKU for each and every item whenever i’m inserting in my database.
THanks in advance
Best answer by MarinaHView original