I'm attempting to transform records that come from a db call (DynamoDB, if it matters), by parsing certain columns of JSON out, and creating discrete columns based on certain keys of those objects. In theory, find() would have solved this for me. Here's a simple example of what that might look like…

Hey Wrapmate! Would you mind sharing a sample return from your DynamoDB query that matches the correct syntax? I think you're correct that it isn't specific to the query itself. One theory is that in some cases inside the Items array, none of your item.cart.items have a type of vehicle. That would…

Transformer fails when referencing key in object returned from .find()

💬 Queries and Resources

Wrapmate October 29, 2021, 2:06pm 3

Adding the optional chaining operator did it!

Here's an exploded view of that data, for reference. Would love to know why that operator was needed in this instance:

Can Transformers Call Queries When Operating Over a Dataset?

Topic		Replies	Views
Can't call transformers in Retool Database Query 💬 Queries and Resources	6	983	February 22, 2024
Need Help with a Join on a Table and API 💬 Queries and Resources resource-connection , query-library , syntax-error , rest-api , query-json-with-sql	19	2704	June 2, 2023
Bug in trasformer 💬 Feature Requests bug	6	1239	October 27, 2022
Preview returning data - but the query is not 💬 Queries and Resources google-sheets , query-json-with-sql	6	4448	August 2, 2023
Firebase Realtime database key / value pair to table 💬 App Building transformer	6	3180	July 27, 2023

Transformer fails when referencing key in object returned from .find()

Related topics