Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error inserting 2000 records or more with CreatedDate #793

Open
congmingwudi opened this issue Jan 27, 2023 · 0 comments
Open

Error inserting 2000 records or more with CreatedDate #793

congmingwudi opened this issue Jan 27, 2023 · 0 comments

Comments

@congmingwudi
Copy link

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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant