Square API - Catalog

I’m using the Square integration to load a catalog and send to postgres. Is there a way to insert zero-based array columns into either the postgres array type or to another normalized table entirely?

Sample column would be present_at_location_ids[0], present_at_location_ids[1], etc…

Either insert that into Postgres text[ ] column, or pivot those columns into a normalized table with the structure catalog_id and location.

Hey @Eric_Cholis!

Happy to take a look at this. Could you give us an example of how the data’s coming in right now, and an example of exactly how you’re hoping the end result will look? Thanks!

Here’s a sample of data from the square integration:

Here’s how I’d like to normalize it:

Hi Eric, stepping in for Ayana!

I created this snippet that should get your data in that format: parabola:cb:9139ed3b-47f9-49a8-b52b-944a56cd5633

It will look like this in your Flow:

Screen Shot 2022-02-25 at 5.07.38 PM

Let me know if you have any questions!