# FileMaker Create Record Error

**URL:** <https://discourse.nodered.org/t/filemaker-create-record-error/71071>\
**Category:** General\
**Created:** [22 November 2022 18:11 UTC](https://discourse.nodered.org/t/filemaker-create-record-error/71071 "2022-11-22T18:11:28Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![deninger](https://avatars.discourse-cdn.com/v4/letter/d/b5ac83/32.png) [@deninger](https://discourse.nodered.org/u/deninger)\
**Post date:** [22 November 2022 18:11 UTC](https://discourse.nodered.org/t/filemaker-create-record-error/71071/1 "2022-11-22T18:11:28Z")

</div>

I have enabled a flow that inserts records into my FileMaker server and it works. Most of the time.

Because I need to know when it doesn't work, I have an Catch node set to flag errors when that node fails which pushes me an alert.

I have had it running all morning. So far it has processed 750 or so records. Four times during this period I have had errors flag: a small percentage to be sure (0.5% of requests). The payload of the request is not abnormal, so it wasn't apparently a mapping issue.

Which begs the question: how can I understand exactly what failed so I can better deal with it?

For example Is it because two requests came too close together? If so, is there a good way to handle this?

Thanks in advance for all of your help!

Mike

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [22 November 2022 20:15 UTC](https://discourse.nodered.org/t/filemaker-create-record-error/71071/2 "2022-11-22T20:15:08Z")

</div>

Do you have a `debug` (Set to display the complete msg object) connected to the `catch` node? If so what does it say?

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [22 November 2022 21:32 UTC](https://discourse.nodered.org/t/filemaker-create-record-error/71071/3 "2022-11-22T21:32:14Z")

</div>

also - are you using flow variables to store "working message" data as it flows through ? If so then yes a new message may be overwriting one already in progress... if so you could just add a delay in rate limit mode if timing isn't an issue - or actually attach/move the value to another msg property, or.... other options are available - but difficult to guess.

---

<div class="post-metadata">

**Author:** ![deninger](https://avatars.discourse-cdn.com/v4/letter/d/b5ac83/32.png) [@deninger](https://discourse.nodered.org/u/deninger)\
**Post date:** [22 November 2022 22:02 UTC](https://discourse.nodered.org/t/filemaker-create-record-error/71071/4 "2022-11-22T22:02:02Z")

</div>

This flow is very simple: data in -\> change to javascript object -\> add a .layout and then create the record. No working message or place to overwrite a message (assuming each flow is a separate thread, something I am not entirely sure of).

I have added a debug to show msg.error going forward. Hopefully this will provide some insight. I have not had an error pop since the four this morning. over 1300 messages today with 4 errors (all early on).

---

<div class="post-metadata">

**Author:** ![deninger](https://avatars.discourse-cdn.com/v4/letter/d/b5ac83/32.png) [@deninger](https://discourse.nodered.org/u/deninger)\
**Post date:** [1 December 2022 15:59 UTC](https://discourse.nodered.org/t/filemaker-create-record-error/71071/5 "2022-12-01T15:59:08Z")

</div>

So I have started logging this error on record create. The error message I am getting is:

object  
message: "The Data API is currently unavailable"

source: object  
id: "64ef211cfd2718bc"  
type: "dapi-create-record"  
name: undefined  
count: 1

This appears to be happening about 1-2 times per day, always at about the same time of day (9:45 am)

Any thoughts on how to track down why the API gives the ghost up like this?

Mike

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [1 December 2022 16:14 UTC](https://discourse.nodered.org/t/filemaker-create-record-error/71071/6 "2022-12-01T16:14:42Z")

</div>

Does your FileMaker server generate a log? Perhaps you can see from there why it was unavailable.

Otherwise perhaps ask on a FileMaker forum.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [30 January 2023 16:15 UTC](https://discourse.nodered.org/t/filemaker-create-record-error/71071/7 "2023-01-30T16:15:29Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.