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

Do’s and Don’ts for Beginner Android Developers

🇸🇪 MySwedish fluency bits #20

Which web development framework is best for your project?

Design and implementation of trajectory control for a wheeled robot with ROS

Weather station based on ESP32 and MicroPython

Setting Up A Keycloak Server For Authenticating To FileMaker: Part 2: Installing Keycloak

Let’s Make Command Line Interface

Ever since I was a little boy, I have only ever wanted to be a Doctor.

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

Mobile Workforce & Agile Workplace with Microsoft 365 Premium

Needfinding — Airport Transportaions

Tune up an upgraded Red Hat CodeReady Studio

CS373 Spring 2022: Vijay Kiran Vuyyuru