Snowfakery icon indicating copy to clipboard operation
Snowfakery copied to clipboard

Error inserting 2000 records or more with CreatedDate

Open congmingwudi opened this issue 2 years ago • 0 comments

I have the following recipe for creating Leads with a generated CreatedDate. This works fine for num_records < 2000. Over 2000 (which looks like where Snowfakery switches to using the Bulk API), fails to insert all rows with this error:

[01/26/23 22:42:50] Job 7505e00000RZbzyAAD finished with result: Row failure: 2000 Errors                                                                    
                    Downloaded results for batch 7515e00000VNdCrAAL                                                                                          

Error: Error on record with id 1: INVALID_FIELD:Failed to deserialize field at col 0. Due to, '2018-09-28' is not a valid value for the type 
xsd:dateTime:CreatedDate --
- object: Lead
  fields:
    CreatedDate:
      date_between:
        start_date: 2018-01-26
        end_date: today
    Firstname:
      fake: first_name
    Lastname:
      fake: last_name
    Email:
      fake: email
    Company:
      fake: company
    Phone:
      fake: phone_number
    MobilePhone:
      fake: phone_number
    Website:
      fake: url
    Status:
      random_choice:
        - Contacted
        - Opne
        - Qualfied
        - Unqualified
    LeadSource:
      random_choice:
        - Advertisement
        - Employee Referral
        - External Referral
        - Partner
        - Public Relations
        - Web
        - Other

congmingwudi avatar Jan 27 '23 05:01 congmingwudi