Search Results for: api

…API key from ChatGPT. See our previous blog post about how to generate an API key. Enter the API key, click sign in, and continue to the next step.   Next, we’ll need to select the model the connector will use. Select gpt-4. After that, click the blue plus button below messages and select “User” in the “Role” text box. Click the blue plus button on the “Content” text box and select the webhook. It will expand to show the JSON array that FileMaker…

More

…script step. At the end of the day, much easier than attempting to set up API access through the Gmail API or some other third-party solution like SendGrid. And the new OAuth option is more secure than the old SMTP protocol settings. Where the Perform Script on Server with Callback script step and the OnWindowTransaction script trigger are significant upgrades in FileMaker 2023, the OAuth component is one of those minor but powerful enhancements….

More

…another FileMaker file, write it to a text file, or push it to an external API. For example, let’s try the first option – create a separate FileMaker file and push the data to that file as part of the script associated with the script trigger. Before coding, let’s think about what that would look like. We want a simple table that captures the log data without causing a never-ending cascade. We want to see when a record in our tables has been creat…

More

…enAI has upgraded the public API offerings. Unfortunately, the ChatGPT 4.0 API is currently in an invitation-only beta phase, with a long waitlist. However, OpenAI has released two new models for developers: ChatGPT 3.5 and Whisper. The ChatGPT 3.5 model features many improvements available through the web user interface – improved language and chat capabilities. Whisper allows for various speech recognition services based on audio files. For exam…

More

…ons. The first thing we want to do is sign up for an account on the OpenAI API here: https://openai.com/api/. Once we have an account, we need to get an API Key. We can do that here:  Once in the API Key section, we’ll click “Create new secret key.”  Let’s copy and save our new key in our favorite text editor. Now, download this sample file and paste the key into the settings area where it says “APIKey.”  We won’t go into the details of the script…

More

…each day in 2023: # Set up a variable to store the API key Set Variable [ $apiKey; Value: “your-api-key-here” ] # Set up a loop to run for each day in 2023 Loop # Set up variables to store the current date and the date of the next day Set Variable [ $currentDate; Value: Get ( CurrentDate ) ] Set Variable [ $nextDate; Value: Date ( Month ( $currentDate ) ; Day ( $currentDate ) + 1 ; Year ( $currentDate ) ) ] # Set up a variable to store the API end…

More

…kBooks actual data. The second part of the URL (https://sandbox-quickbooks.api.intuit.com/v3/) tells the API what company we want to pull the data from, in this case, our sandbox company. The next portion, “/company/realmId,” is the real gist of the thing, and that is the specifics of what we’re dealing with on the QuickBooks Online side of things; QuickBooks calls this a query.  “query=select * from Customer Where Metadata.LastUpdatedTime > ‘2015…

More

…pen within a day. The refresh token lasts for 100 days if we don’t use the API but will refresh indefinitely if we use the API more than once every 100 days.  Now that we have our access and refresh tokens let’s learn how to activate them. We do this so we don’t have to go through the effort of signing into our account using a name, password, and 2-step verification again and again whenever we make a call to the API. The script we will likely use…

More

…ions and services, thereby extending their capabilities and functionality. API TOKEN Let’s first start with turning on the QuickBooks Online API. Head over to: developer.intuit.com and sign in. Then click on the Dashboard link in the upper right: Once you get to the Dashboard, you can create a new app by clicking on “+ Create an app” button. Think of this app as a representation of your FileMaker solution in QuickBooks. After clicking the “+ Creat…

More

…o encrypt the name and password of the user we just setup: Base64Encode ( “APIUser:apipassword” ) = QVBJVXNlcjphcGlwYXNzd29yZA== The last thing we need to do is create fields where we can insert the Jotform data. In this case, I have two text fields: FirstName and LastName. That is all we have to do on the FileMaker side of things for now. Next on to Zapier. Since we decided to gather our initial data from Jotform, let’s add that as the first step…

More

…browser in the guise of Edge and its inclusion as the underlining Windows API for executing browser code, Claris could safely shift to it for running JavaScript and displaying HTML. Incidentally, Edge is the underlining engine of Google Chrome and Apple Safari, to some extent. So throw open the doors and experiment with web viewers and FileMaker’s recent JavaScript enhancements with abandoned regard to your target user’s operating system. APPLE S…

More

…e last decade. Please note: several FileMaker technologies, like the Admin API and the Data API, don’t work with Claris’s default certificate installed. There are two powerful reasons to get a custom SSL certificate: encryption-on-the-fly and server spoofing. Encryption on the fly allows the data between the client and the server to be encrypted by the SSL certificate so that some bad actor who is listening in on network traffic can’t poach it. An…

More