That would be great — thanks for the quick response.
Is there any reasoning why certain fields aren’t supported? Is there a list anywhere of fields that aren’t supported. Any estimation on how long it would take for support of those fields to be added?
When I manually add an employee and put random text in the ListID field, I get no errors. When I try to run an APPEND query with 100+ employees to add to the table and an expression with random text in the ListID field, I get a failure due to key violations. Does this mean there is not a way to bulk insert new records into a table synced with Quickbooks?
EDIT: Figured it out, I had to make ListID non-unique, and not required, then it worked fine.