![]() ![]() ![]() This video provides a comprehensive understanding of how curl is integrated into FileMaker and how you can use a freely provided script to manage all your REST based interactions. The cURL library was already being used by FileMaker and it was simply a matter of "opening things up" so developers could use the full suite of the cURL library.īy adding the cURL options calculation to the Insert From URL script step the world of the web opened up for our humble FileMaker Pro. When native JSON was added to FileMaker, the last piece to the puzzle was a more expanded method of interacting with the network. In the case of using REST (Representational state transfer) to interact with service APIs within FileMaker, it's nice to have a single tool which will handle most of the heavy work for you. In fact, in much of technology, there's something or someone somewhere which has likely already solved the problem. Do this at the end of the script and then commit record.Do you need to work with online APIs and find yourself wishing there was an easy way to accomplish it? Well, there actually is. Uses the Get (CurrentDate) function to insert the date into the ChangeDate field (thus capturing the date the change was made).īefore the script finishes be sure to use "set field" back in the original table to move the value in z|newprice field into your normal Price field. Uses the "set field" script step to insert info to this new record in the ArchivePricing table. ![]() ChangeDate, Price, Item, ItemID, etc.).Ĭreate a new field in the current table called z|newprice - use this to type in your new pricing (you might do this on a list layout so you can easily change a bunch of prices).Ĭreate a button that triggers a script that:Ĭreates a new record in the new ArchivePricing table and inserts the ItemID (thus creating a link to the original table) - this can be done using script parameters or setting a variable). ![]() ArchivePricing) to hold the values you want to reference at a later date (e.g. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |