JSON Filemaker API Execution

[KAY FLUHR]

Next point someone already has experience with? I am playing around with the new script step Filemaker Data Api execution.

I am getting results with this:

JSONSetElement ( "{}" ; ["layouts";"Forms";JSONString]; ["limit";Get(FoundCount);JSONNumber] )

all fine, but how to execute the _find command?

 

 

 

[bcooney]

https://www.geistinteractive.com/2020/05/20/filemaker-19-execute-filemaker-data-api-script-step/

 

you're missing the query array element. For example,

{
"layouts" : "People",
"limit" : 500,
"offset" : 1,
"query" : [ {"City" : "Denver"}],
"sort" : [{"fieldName": "LastName" , "sortOrder": "ascend"}]
}

[IdealData]

Can you point me to this new script step in the online help guide please.

https://help.claris.com/en/pro-help/#page/FMP_Help%2Findex.html

 

[bcooney]

It isn't documented -- yet

[LaRetta]

https://support.claris.com/s/article/Execute-FileMaker-Data-API?language=en_US

This?  I think it just came out. 🙂

Edited May 22, 2020 by LaRetta

[IdealData]

Thanks Laretta. Now i just need my download links that are now 72 hours overdue!

[Wim Decorte]

I believe that if you go to the download page from your existing license, you'll see the new downloads and your 19 keys.  Ours were available like this early on Tuesday, even without getting the notice.