Update For FileMaker Pro 19.4: Exploring The Execute FileMaker Data API Script Step

What Does It Do?

What’s Changed?

{
"messages" :
[
{
"code" : "1708",
"message" : "Unknown key (offset.email_portal_object)"
}
],
"response" : {}
}
"messages" : 
[
{
"code" : "0",
"message" : "OK"
}
]

What’s The Format Of The Query?

{
"action":"read",
"version":"v1",
"layouts":"Contact Details",
"layout.response":"Contact Details",
"limit":1000,
"portal":["email_portal_object"],
"offset.email_portal_object":2,
"limit.email_portal_object":3,
"query":[{"First Name":"==John"},{"Last Name":"==Williams"}],
"sort":[{ "fieldName": "Last Name", "sortOrder": "descend" },{ "fieldName": "First Name", "sortOrder": "ascend" }]
}
"portalData" : 
{
"email_portal_object" :
[
{
"Email Addresses::Address" : "john_abc@example1.com",
"Email Addresses::Type" : "Personal",
"modId" : "1",
"recordId" : "10"
},
{
"Email Addresses::Address" : "john_abc@example2.com",
"Email Addresses::Type" : "Personal",
"modId" : "0",
"recordId" : "11"
},
{
"Email Addresses::Address" : "john_abc@example3.com",
"Email Addresses::Type" : "Personal",
"modId" : "0",
"recordId" : "12"
}
]
},
"portalDataInfo" :
[
{
"database" : "EXECUTE_FILEMAKER_DATA_API",
"foundCount" : 5,
"portalObjectName" : "email_portal_object",
"returnedCount" : 3,
"table" : "Email Addresses"
}
],

Conclusion

--

--

--

FileMaker Developers; Keycloak Enthusiasts; Data Magicians

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

How to convert a Word DOC 97–03 Document to Text TXT in Python

THM Linux Fundamentals2 (Updated)

Python program to find factorial of a given number

Using the Operator Lifecycle Manager to deploy Prometheus on OpenShift

99% Code Coverage — Do We Have A Good Safety Net To Change This Legacy Code?

PostgreSQL Row-level security and More…

How to Know if My Corrupted Access Database is Beyond Recovery

Lessons Learned From Ansible

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Sounds Essential

Sounds Essential

FileMaker Developers; Keycloak Enthusiasts; Data Magicians

More from Medium

Journey of DLithe Bootcamp .NET Full Stack Week 2(Jan31-Feb5)

5 Things to Know about Multi-Factor Authentication

Learn How To Create A Module Magento 2 ! — MyWebDiary |

How to Create Auto Generate Slug in Strapi 4