Best answer

DynamoDB integration with Google Sheets

  • 30 December 2022
  • 2 replies
  • 74 views

Userlevel 1

Hi! I'm trying to connect the integration of data from a DynamoDB table to a Google Sheets table.

But at the stage of connecting DynamoDB, the timestamp field is invisible, although there is such a field in the table and it has the unix timestamp format. Instead of the timestamp field, the “id” field is defined, but the integration does not work with it.

Can someone tell me what could be the reason?

icon

Best answer by Danvers 30 December 2022, 14:46

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +12

Hi @Andrii Datskiv, welcome to the Community!

 

We’ve found that some users have trouble with their timestamp field when it’s set in Unix format because it’s incorrectly read as a text field.

We know that at least one user has been able to reference their  Number-type timestamp field by declaring it as a Custom Value: 

 

 

​I hope that helps, please let us know if you have any questions!

Userlevel 1

Thanks! That way is working!