FileMaker DataAPI / oData

We have a JavaScript-based custom web interface to a FM database running on FileMaker Server v20.1.2.207, macOS 13.7.2. Everything is working well, but our security-mandated Rapid7 scans report the following vulnerabilities: TLS/SSL Server Supports The Use of Static Key Ciphers TLS 1.2 ciphers: TLS_RSA_WITH_AES_128_CBC_SHA TLS_RSA_WITH_AES_128_CBC_SHA256 TLS_RSA_WITH_AES_128_GCM_SHA256 TLS_RSA_WITH_AES_256_CBC_SHA TLS_RSA_WITH_AES_256_CBC_SHA256 TLS_RSA_WITH_AES_256_GCM_SHA384 HTTP OPTIONS Method Enabled I'm assuming the relevant config file to edit is /Library/FileMaker Server/HTTPServer/conf/extra…

Forgive the potentially ignorant question here, but I built a trading journal app a couple years back that retrieves market quotes via TD Ameritrades developer API.. since they've been acquired by Schwab and migrated their API, they've implemented Oauth2 where apparently the auth token now expires and must be renewed or retrieved again via a redirect and callback URL... Given this is a stand alone app running in Pro, it appears based on some research that I won't be able to authenticate via this new method, since I'm not hosting a server... Can anyone experienced in these matters confirm or deny my conclusion? And if it is possible give me a point in the right direction? …

We would like to be able to trigger payment orders through the Revolut Merchant API from FileMaker. We have the merchant account set up but I just need to understand the vagueries of calling the API from a FileMaker script step. I have no experience with accessing secure APIs. Has anyone any knowledge of this who might be bale to point me in the right direction or have any example scripts for similar APIs that I might be able to doctor? Many thanks

Hello All - I have a script that that uploads an XML Payload to my merchant service to process credit cards. I have been using this script since 2016 and Pineapple Payments (formally Nelix/Transax) moved servers and added coding to include a SOAP envelope. I'm using a Set Variable for the cURL options on the Insert from URL script step. My coding works in Postman but NOT Filemaker 19. I get the error from the Transax Server : <soap:Reason><soap:Text xml:lang="en">Server was unable to process request. ---&gt; Data at the root level is invalid. Line 1, position 1.</soap:Text></soap:Reason> Does FMP 19 support SOAP? Here is the Set V…

I'm building some php pages that use FileMaker's Data API to pull records from my filemaker database using fmPDA's fmDataAPI library. I'm running into problems when trying to view files from a container. I'm using the url returned in the JSON response in an image tag to view a jpeg. But it's not showing. echo '<img src="' . $responseData[0]['fieldData']['logo'] . '" />' As I understand it I should be able to take the url provided in the JSON response like the one below, plug it into a web browser and view the image. https://dev.rgcdata.com/Streaming_SSL/Additional_1/12119404ADCC7E2C307D1FE70AAFE2D0E551A65E9DF89BE17876AE537567464A.png?RCType=EmbeddedRC…

Hi, I would like to create a link from a Filemaker database to Azure, to be able to invite users using their email address from a click of button. https://docs.microsoft.com/en-us/graph/api/invitation-post?view=graph-rest-1.0&tabs=http Also to update group memberships of the associated email in Azure. I'm struggling with what commands are needed to a make this happen. Has anyone has any experience with this type of connection?

Hello as part of an issue connecting to Filemaker from an app I thought I would go back a step or two and try to connect from postman. Unfortunately I still get an authentication error. This is my Connection string for the POST command https://fm-arina.account.filemaker-cloud.com/fmi/data/v2/databases/UNDA-Space-Data-2022/sessions Authentication using "Basic Auth" API is turn on in cloud "fmrest" extended privilege is checked Here are a couple screen shots which may or may not be helpful. Thanks in advance

I have a solution in Cloud 2 - does anyone know if it is possible to connect a QGIS project to filemaker (in the cloud)?

Im trying to request a access token and Im receiving the following error message. {"messages":[{"message":"Unexpected token % in JSON at position 0","code":"1630"}],"response":{}} Its just a test database hosted on a windows server v19 and Im connecting via a Prepress workflow Server that has a 'Interact with Web Service' module I can retrieve a list of hosted files but as soon as I change to a POST method and supply Authorization it errors. I've checked the u/p and that's correct. Ive tried different variations of suppling the login details and all comeback with same error. The response from the GET hosted files: {"response":{"databases":[{"name…

Hi mates, I hope this is the proper section to ask. I'm building up a scale to weight products and I need to transfer the value to file maker, real time. The idea is to create a server on Arduino and polling it when needed, which is the best way? (Easily supported by both) Maybe telnet session, or an http reporting the last value only.. other ideas? Thank you!

I am working on a interface to submit claims to an insurance clearing house. I am able to create the JSON and submit the claim but the clearing house won't accept some empty fields. As a result, I would like to make sure there are not empty values in the required key/value pairs. Is there an easy way to quickly do this after the JSON is built? I realize it could be done when building the JSON but I'm trying to write scripts that only do one thing at a time. Thus, a script to check the JSON before submitting it. If there isn't, I'll just write a script to check all the FM fields before creating the JSON. Thanks for any help you can provide. { "Cla…

I need to send a JSON string containing 1000+ objects with data to be replaced into fields in a Filemaker layout. Currently looping a NodeJS method which is taking a large Node heap allocation, and clearly the ideal way to do this is to send the data for all records in one request and loop through it within Filemaker via a script. Closest thing I can see in the documentation is - run a script and pass a parameter that is the JSON string. But what is the size limitation on the parameter? Anyone actually performed a bulk operation in this manner? Kirk

Hello, Any good tutorials/videos on how to implement zoom API with filemaker? Thanks

I am trying to set a global variable on a layout, then run a find query using the Data API. I get a successful response to the request to set the global field, but then when I post the find query url, I get no records found. Is the global variable I set sticking for the subsequent find request? I'm worried its not and I don't know how to make it stick if that's the case. Thanks for any ideas.

Hi everyone, I have a problem with getting a list of records to show in my web app. Every time I make a GET request from my Node server the FMS 19 Data API returns a response with the body compressed. I am sure that my request is good because it works in Postman, returning all the records of my layout as JSON. I am confused because I read that the browser is supposed to automatically handle any compression but nothing I have tried seems to work. I have used the zlib library to try to "unzip" the data returned from FMS but have not had any luck. I was wondering if anyone has experienced the same problem and/or can tell me what I might be doing wrong. M…

Hello all! I have been working with a FileMaker solution (currently 17) that has a companion web site which is heavily used by potentially hundreds of clients outside of the main office. They are essentially customers of the business. They use the web interface (PHP based) for mission critical work, including submissions of orders (creation, edit, delete, etc.). It is used 24x7. There were 142k calls to the site yesterday, as an example of the usage. Currently about 60% of calls that are related to orders are performed through CWP. The other remaining calls are through the data API. I am in the process of converting the remaining CWP calls to Data API. I also r…

Good day I'm trying to figure out how I can trigger a data dump script via the data api. I checked the documentation, but couldn't quite wrap my head around the layout part. The script I want to run basically runs an ExecuteSQL statement and dumps the data to csv. Do I need to add it to a layout somehow? Any assistance would be greatly appreciated!

Hi there, Currently looking at a solution, and seeing that there are accounts used from the data api that also have [full access] permission. Furthermore, people are also logging in per FM Client with this account ... PLEASE - someone provide me with a sanity check and tell me this is indeed wrong (as I fully think it is)? Thanks in advance G

I wonder if anyone has successful communication with dRofos software https://wiki.drofus.com/display/DV/API or any other comments? Thanks John

Good morning. Given the attached sample JSON file, if JSONGetElement($JSON ; "main.temp") returns what I want, how do I format the JSONGetElement command to extract the data for Weather; Icon please - there is an extra "level" I don't know to access. I'm sure it's just a character or two. Thoughts please. Greg Sample.XML

Hi. Is it posible to make bank transfers to select accounts from 1 bank. For the task of processing wages/payments to clients etc. Also can you track incoming bank transfer payments from clients into a select bank account? Perhaps a plugin already exists? Using FM Pro 17. Thanks Laurence

Hi! I hope someone can shed some light on the following issue. I am looking for the way how I could fill out web form using data from several FM fields, submit the form and copy/paste the resultant image to a container field. While URL of the web page that shows the form is always the same, URL of the resultant image changes every time the image is generated (therefore Insert from URL function is not really applicable or I don't now how to use its full potential) I did some research and found various ways how this could be possibly done: 1. Export fields to CSV and use Imacros or similar macro recorder to finish the job 2. Use various plug-ins like Tro…

Trying to create a record on FMS18 using its API, sometime I get an error response: {"messages":[{"code":"1708","message":"Parameter value is invalid"}],"response":{}} I know what this means, but i wonder if there is a way to get back from FMS, with the error message, which parameter (field) is the culprit. I am pretty sure that, having to deal with US and European date format, my seldom error depends on this. But the error message is so vague... Thanks

Hello. I'm trying to determine proper format for calling a script via API and passing a JSON parameter. I'm running the following as a GET via Postman, targeting FMS17: https://SG-FMS/fmi/data/v1/databases/APITarget/layouts/APIOpen/records/1?script=StoreResults&script.param=TEST The script is called, and receives the parameter 'TEST'. However, using only a GET URL , I'm unable to pass a JSON payload. I'm having trouble finding references to proper syntax for constructing a POST API call to run a script and pass data. Thanks!

"For inbound Data Requests (pulling data into the database on your FileMaker Server) you have unlimited API Data Transfer. For outbound Data Requests (pushing data out from the database on your FileMaker Server) you are limited to the API Data Transfer included with the Software along with any additional API Data Transfer that you purchase." sic - https://support.filemaker.com/s/article/Understanding-the-Data-API-Annual-Limits?language=en_US Does this mean that when I do a query `curl -kL -XPOST fmserver/fmi/data/v1/databases/some/params -d "more:params"` The query I send to FileMaker is for free? But its response does a countdown on my allowance?

Hi I am trying to find a good map source in web viewer (without the clutter that Google embed in recent maps). My users press a button to get the iPhone/ipad to get locality coordinates (decimal degree) from the GPS and tjhe lat long fields are filled out. But I can not find an URL that gives me a good clean map / satellite picture of the area their in without all the extra noise. Google gives a lot of extra boxes that takes place and disturbs the information I want the user to have. The best would be if the URL service also could to get a mark at the spot given by the GPS, but that is not necessary. Do anybody have a suggestion for this?

I'm not sure which topic to put this question in so please move if this is the incorrect section. I am looking to create a customer link, on an individual customer basis. I would like to email this link to a customer, the customer clicks on the link and the code navigates the user to a webpage where they are shown their current information and fields next to this to update and input their own information and click submit. On clicking submit, the data gets returned to the correct file within filemaker and at the users discretion can automatically update the file. Can someone point me to a developer or software that can help me make this happen? Thank yo…

How do you query the index of a FileMaker field using FileMaker Data API? The FileMaker equivalent would be to push ⌘ + I I'm not asking how to achieve a sorted unique list of 10 000 000 records, I'm asking how to extract the n possible values from the index of the field in question. Where n probably is between 5 and 20. A poor man's solution to this is obviously using a value list; delivering the ideal values of the filed, but that's like positive testing and that will not deliver what I ask for.

when inserturl do not have a response it freeze and wait, then i tried using curl : --connect-timeout 1 but it doesn work. please how to interupt the execution on inserturl command at e specific time. testcurl.fmp12

I am trying to use the BaseElements plugin to GET and POST data to Wunderlist using their API but haven't been successful in figuring out the correct steps yet. I have used BE plugin before with SendHub to send text messages directly from FileMaker. It took lots of playing around with it before I finally figured it out. I know Wunderlist is going to be pretty close to the same I just don't have much experience with this and need a little guidance. Once I can successfully GET/POST data I can probably take it from there. I am having trouble figuring out the proper formatting of the headers etc to allow access to the GET and POST commands. Mainly just wanting to POST t…

Hello, I think I'm about to understand things around REST API and how to use them from my terminal when I see APIs documentation. I'm fighting a lot with the use of quotes when I want to use them from a FileMaker file. For example the following code works very well from my terminal (it's an example that you can try from IBM watson): (It's a text-to-speech service that provide a sound file made with the text you sent) curl -X POST -u login:password \ --header "Content-Type: application/json" \ --header "Accept: audio/wav" \ --data "{\"text\":\"My name is Christophe\"} " \ --output hello_world.wav \ "https://stream.watsonplatform.net/text-to-speech…

Hi, I find my self hitting the wall, again and again, trying to make a POST call to an API using Insert from URL curl. When I try the code in POSTMAN it works very well, but trying to translate the curl options into Filemaker is where I fail. This is my POSTMAN code: curl -X POST \ https://www.correosexpress.com/wpsc/apiRestSeguimientoEnvios/rest/seguimientoEnvios \ -H 'user: username:passowrd' \ -H 'Content-Type: application/xml' \ -H 'Postman-Token: ff84b952-74c8-f06b-976d-f860d9d66de7' \ -d '<?xml version='\''1.0'\'' encoding='\''UTF-8'\''?><SeguimientoEnviosRequest xmlns:xsi='\''http://www.w3.org/2001/XMLSchema-instance'\'' xsi:noN…

I'm trying to retrieve a list of farmers using the url with the following format: http://encodedCredentials@host/fmi/xml/fmresultset.xml?-db=My System&-lay=FAR__Farmer&-findall I know the url is correct as I can retrieve dbnames. However when trying to get the list of farmers I get a java.io.FileNotFoundException which I think means it can't find the db name. Would the blank space in the db name be the issue? I have tried to replace the blank space by %20 but the exception is also thrown. When run in the browser it throws: 502 - Web server received an invalid response while acting as a gateway or proxy server. Any thoughts?

For anyone interested in an npm package that communicates with Filemaker's data API, I am currently developing here - https://github.com/thomann061/fmrest