API_ImportFromCSV deletes users from List-User field

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

We have a record that had a List-User field in it.   This field has 2 users we manually added to it. When we run our cron job which uses the API_ImportFromCSV to update this List-User field, any user in the List-User  field which is not in the CSV import get deleted.   


Is this normal?  We thought that the import only adds and updates a List-User field.  not deletes.

Photo of Ryan

Ryan

  • 200 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,448 Points 50k badge 2x thumb
While have not specifically used import into a List User field, in general anytime you import into a field it gets overwritten with the new value whatever that may be. For example if you import a blank into a field then that is what you get.
Photo of Ryan

Ryan

  • 200 Points 100 badge 2x thumb
We are still having the same issue right now, so hoping for more insight with this.