Other: New Column Needed
Answered
We're using Fivetran to warehouse our QuickBooks data into a database, we're looking to aggregate this data by customer_type_name, but we're facing an issue where the 'customer' table contains the customer_type_id column, but it doesn't contain the customer_type_name.
There's nowhere else in the DB that contains the customer_type_name that we can use to map the data.
It would be great if we can have the customer_type_name column inside the 'customer' table, or have a new table 'customer_type' based on the customer_type object in the API that contains both the ID and the name, this way we can connect both tables using the ID therefore retrieve the customer_type_name for each customer.
Thank you in advance.
-
Official comment
Hi Underberg,
Thanks for your feature request. While adding the requested feature is not in our current timeline, we've added it to the backlog. We recognize the importance of having the 'customer_type_name' in the 'customer' table for data aggregation.
Considering it seems like an easy item in terms of effort, we plan to implement it soon. This will likely involve adding the 'customer_type_name' column to the 'customer' table or introducing a new 'customer_type' table based on the customer_type object in the API.
We appreciate your patience and will keep you posted on the progress.
Best regards,
Sandeep
Technical Product Owner
Please sign in to leave a comment.
Comments
1 comment