Zab37

Hello I finally got time to test the Geist Generator and it is simply awesome (I'm having lot of fun ;-). Thank you for this link. I am getting quite good at integrating this. I have a question. My list is around 800 items and I could simply update those that were changed since the last request date & time. In my imported file there is this field: "last_modified_time" : "2021-11-25T15:03:38-0500", as explained here in the response : https://www.zoho.com/books/api/v3/#response But I can't find a way to access it within my param. Do you have any idea if it's possible ? even if it's not part of the API items elements here: https://www.zoho.com/books/api/v3/#Items if not I will Get everything and script it to find everything greater than the last update. Thank you.

Hello Again and thanks Barbara for the links. I’m stuck again, and need your kind help. I’m advancing, I setup everything on Zoho, I asked for my token, manage a script in FM that refresh the token with a -X POST. Now I want to GET the list of items and nothing works from FM but it works just fine from Postman. I checked and re-checked the link, url. My feeling is there is something I do wrong with the cURL, a syntax problem maybe ? Thank you. I’m sending some screenshot in the hope that you can see the error.

Thank you that's what I was looking for. A file with examples to wrap my mind around. Then I guess I'll do it all from Filemaker. I have already connected to Books with Postman and it works great. So I'll just Get everything and parse it. I'll keep the "webhook' notion in mind in case they answer me back. I think it would be the best to update one price at a time instead of getting and parsing thousands everyday, it seems like a waste of energy and bad practice. but hey... one day. Or I'll try to find a way to get only those that were modified today... Thanks a lot bcooney

The thing is yes I am confused. I'm new to this API, REST JSON and POSTMAN world. Put simply Zoho Books is online accounting system. I know it can connect with many APIs but it's not automatically setup for FM. It's still possible to do it. So I extracted an excel files of my items in Books, started a new Filemaker DB with it, using only the important fields, id, sku, barcode, item_name, category and purchase_price. So far so good. Now I'm looking for the right steps to keep my prices up to date in FM (to include them in a Bill Of Materials). Is it best to script the JSON in FM, Get everything and parse, loop, update this way? In Books, I have my user, my secret question, I can generate my Oath with Postman, But I have to do it everyday. Maybe I only need an example on how to regenerate automatically my token, and a script to do it in FM so I can GET and update those prices easily on demand, from a button. I'm sure it's simple , I just never use JSON. Logically it seems it should be done from Books, if the price is updated, BAM it's posted in the same item in FM. But I can't get help from them. I hope it's clearer and I used the right words this time. 😉 Thanks again. I will eventually learn how to do this in my sleep, but I just need a quick fix to finish that big project.

Hi everyone. It's been a long time since I got here, I even lost my old ID (couldn't find the email I used;-) . Wow This forums as evolved big time. I need this great community once again. I really need some pointers from experiences JSON users. Because I'm totally new there. Here's what I need to do. I have created a FM db with a PriceList imported from Zoho Books/Items. I want to update the latest prices from Zoho Books/items. I'm not sure which way to go and what to learn first. Because there will be more of this type of integration between Zoho One and our FM databases. From my first researches I see a lot pf people using Postman, I played a bit with it and I think I got the basics. Still I'm not sure if I need to use it. Those are the different ways I see it. 1. I import (or it's done automatically) the price from one item from Zoho one to FM using JSON - Problem is, the Zoho support seems quite poor. I can't find much help there. 2. I make a script directly into FM to update, once a day, all records with JSON ? Need to learn how. An example would be nice. 3. I do it with Postman? but how? I don't want to waste time learning this now if it's not needed. I haven't find the right way to update the OAuth , it looks like I need to do it every day. So I'm lost a bit, if anyone can give me some pointers or formation to what is the right way to do this and where to start, and maybe a good video/formation, I'd appreciate it. I keep looking. Thanks a lot Isabelle