Ryan A•6mo 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•6mo ago

BuildShip AI Support - Crafting Solution, (Avg response time: ~2 minutes 🙂)

Ryan AOP•6mo ago

Also tried creating a node using the AI generator - but whatever I try, I get a ...is not a function error.

AI Support•6mo 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.