Ryan A Posts - BuildShip

Ryan A

•Created by Ryan A on 7/14/2024 in #❓・buildship-help

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?

5 replies

BBuildShip

•Created by Ryan A on 7/10/2024 in #❓・buildship-help

Get path/ref from field value?!?

22 replies