Ryan A
Ryan A3mo ago

Updating target firestore doc with timestamp from another table

I receive a firestore timestamp field in a changed row - I am trying to write that value out (as is) to a different firestore document using the Firestore Create Document node. The inboundDateTime that I am received is in this format (which I believe is Firestore timestamp... and can't work out how to parse and use to update target document!
"createdDateTime":{
"_nanoseconds":550000000
"_seconds":1720261349
}
"createdDateTime":{
"_nanoseconds":550000000
"_seconds":1720261349
}
___ Try 1:
targetDateTime: (x)Row.inboundDateTime
targetDateTime: (x)Row.inboundDateTime
Try 2:
targetDateTime: (x)Row.inboundDateTime.toDateString()
targetDateTime: (x)Row.inboundDateTime.toDateString()
...as well as
toDate()
toDate()
Return: ...stating
ctx.root.rowy-trigger.row.inboundDateTime.toDateString is not a function
ctx.root.rowy-trigger.row.inboundDateTime.toDateString is not a function
Return: ...stating
ctx.root.rowy-trigger.row.inboundDateTime.toDate is not a function
ctx.root.rowy-trigger.row.inboundDateTime.toDate is not a function
Try 3: I have seen examples of formatting the date in Javascipt before returning - but cannot work out where to inject that JS code as the Firestore Update Document node ('data' parameter') appears to just want a {field1: vale, field2: value} code block. (Idea influenced by https://discord.com/channels/853498675484819476/1173147442661818368) Any ideas?
3 Replies
AI Support
AI Support3mo ago
BuildShip AI Support - Crafting Solution, (Avg response time: ~2 minutes 🙂)
Ryan A
Ryan A3mo ago
Also tried creating a node using the AI generator - but whatever I try, I get a ...is not a function error.
AI Support
AI Support3mo ago
It seems you are encountering issues with the AI-generated node. This might be due to incorrect function definitions or usage within the generated node. To troubleshoot and resolve this issue, please review the node's logic and ensure that all functions are defined correctly and are being called appropriately. If the problem persists, you can reach out for further assistance. For more details on how to create and modify nodes using the AI Node Generator, you can refer to the AI Generated Nodes documentation. If you continue to experience issues, please submit your query via the in-app support button for more personalized assistance.