Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: Defect with Expensify Connector

Completed
James Gould User

We have some Expensify expenses which are not being synchronized properly, the columns are jumbled up.

 

This appears to be when the comment on an expense contains a "," (comma) character, i believe your code may be converting to CSV but not accommodating for specific characters in the free text fields,

 

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Official comment
    Vishal Ray Fivetranner

    Hi James,

    Thank you for reporting this issue. We have resolved this in our Expensify Connector now.

    Please raise a support ticket if you see any other issues.

    Thank You,

    Vishal

  • James Gould User

    sorry the field in question is the expense "Description" in the expensify api, in Snowflake we see the column being called comment.

     

    Here is an example of a value in Expensify "[Team meal] Dinner first night of CKO 2024 after flying in [x16 people, $16.70/pp]" in Snowflake we see "[Team meal] Dinner first night of CKO 2024 after flying in [x16 people"  and columns after this are in the wrong order.

     

    However... i do see other description fields with a comma which are synchronizing correctly.