Skip to content

Instantly share code, notes, and snippets.

@JeroenSfdc
Created May 30, 2020 22:50
Show Gist options
  • Save JeroenSfdc/a8d15c725e14090b3413ac1f20d58b61 to your computer and use it in GitHub Desktop.
Save JeroenSfdc/a8d15c725e14090b3413ac1f20d58b61 to your computer and use it in GitHub Desktop.
{
"objects": [
{
"operation": "Insert",
"externalId": "Id",
"mockFields": [],
"updateWithMockData": false,
"mockCSVData": false,
"deleteOldData": true,
"allRecords": true,
"useCSVValuesMapping": false,
"query": "SELECT Id, SBQQ__ParentCustomAction__c, CurrencyIsoCode, Name, SBQQ__Action__c, SBQQ__Active__c, SBQQ__BrandButton__c, SBQQ__Class__c, SBQQ__ConditionsMet__c, SBQQ__Default__c, SBQQ__Description__c, SBQQ__DisplayOrder__c, SBQQ__EventHandlerName__c, SBQQ__IconClass__c, SBQQ__Icon__c, SBQQ__Label__c, SBQQ__Location__c, SBQQ__PageHandlerName__c, SBQQ__Page__c, SBQQ__ReturnURL__c, SBQQ__TargetObject__c, SBQQ__Type__c, SBQQ__URLTarget__c, SBQQ__URL__c FROM SBQQ__CustomAction__c",
"deleteQuery": "SELECT Id FROM SBQQ__CustomAction__c"
},
{
"operation": "Insert",
"externalId": "Id",
"mockFields": [],
"updateWithMockData": false,
"mockCSVData": false,
"deleteOldData": true,
"allRecords": true,
"useCSVValuesMapping": false,
"query": "SELECT Id, CurrencyIsoCode, Name, SBQQ__Template__c, SBQQ__Alignment__c, SBQQ__BottomMargin__c, SBQQ__ColumnHeadingField__c, SBQQ__ConditionalPrintField__c, SBQQ__DisplayOrder__c, SBQQ__DynamicNumberScale__c, SBQQ__FieldName__c, SBQQ__FontFamily__c, SBQQ__FontSize__c, SBQQ__FontWeight__c, SBQQ__HeadingTextColor__c, SBQQ__HideOnComponents__c, SBQQ__LeftMargin__c, SBQQ__RightMargin__c, SBQQ__RollUp__c, SBQQ__SeparateLine__c, SBQQ__SubGroupSummaryLabel__c, SBQQ__SummaryFontWeight__c, SBQQ__SummaryFunction__c, SBQQ__SummaryLabel__c, SBQQ__SummaryLevel__c, SBQQ__SummaryShadingColor__c, SBQQ__SummaryTextColor__c, SBQQ__TextColor__c, SBQQ__TopMargin__c, SBQQ__WidthDiscardedWhenHidden__c, SBQQ__Width__c, Key__c, SBQQ__Section__c FROM SBQQ__LineColumn__c",
"deleteQuery": "SELECT Id FROM SBQQ__LineColumn__c"
},
{
"operation": "Insert",
"externalId": "Id",
"mockFields": [],
"updateWithMockData": false,
"mockCSVData": false,
"deleteOldData": true,
"allRecords": true,
"useCSVValuesMapping": false,
"query": "SELECT Id, SBQQ__Product__c, CurrencyIsoCode, Name, SBQQ__Category__c, SBQQ__Message__c, SBQQ__Required__c, SBQQ__Type__c, SBQQ__Value__c FROM SBQQ__LookupData__c",
"deleteQuery": "SELECT Id FROM SBQQ__LookupData__c"
},
{
"operation": "Insert",
"externalId": "Id",
"mockFields": [],
"updateWithMockData": false,
"mockCSVData": false,
"deleteOldData": true,
"allRecords": true,
"useCSVValuesMapping": false,
"query": "SELECT Id, SBQQ__PriceRule2__c, SBQQ__ProductRule__c, SBQQ__TestedConfigurationAttribute__c, CurrencyIsoCode, Name, SBQQ__LookupField__c, SBQQ__MatchType__c, SBQQ__Operator__c, SBQQ__TestedField__c, SBQQ__TestedObject__c, SBQQ__TestedValue__c, Description__c FROM SBQQ__LookupQuery__c",
"deleteQuery": "SELECT Id FROM SBQQ__LookupQuery__c"
},
{
"operation": "Insert",
"externalId": "Id",
"mockFields": [],
"updateWithMockData": false,
"mockCSVData": false,
"deleteOldData": true,
"allRecords": true,
"useCSVValuesMapping": false,
"query": "SELECT Id, CurrencyIsoCode, Name, SBQQ__Rule__c, SBQQ__Field__c, SBQQ__Formula__c, SBQQ__Order__c, SBQQ__SourceLookupField__c, SBQQ__TargetObject__c, SBQQ__ValueField__c, SBQQ__Value__c, Description__c, SBQQ__SourceVariable__c FROM SBQQ__PriceAction__c",
"deleteQuery": "SELECT Id FROM SBQQ__PriceAction__c"
},
{
"operation": "Insert",
"externalId": "Id",
"mockFields": [],
"updateWithMockData": false,
"mockCSVData": false,
"deleteOldData": true,
"allRecords": true,
"useCSVValuesMapping": false,
"query": "SELECT Id, CurrencyIsoCode, Name, SBQQ__Rule__c, SBQQ__Field__c, SBQQ__FilterFormula__c, SBQQ__FilterType__c, SBQQ__Index__c, SBQQ__Object__c, SBQQ__Operator__c, SBQQ__TestedFormula__c, SBQQ__Value__c, SBQQ__FilterVariable__c, SBQQ__TestedVariable__c FROM SBQQ__PriceCondition__c",
"deleteQuery": "SELECT Id FROM SBQQ__PriceCondition__c"
},
{
"operation": "Insert",
"externalId": "Id",
"mockFields": [],
"updateWithMockData": false,
"mockCSVData": false,
"deleteOldData": true,
"allRecords": false,
"useCSVValuesMapping": false,
"query": "SELECT Id, CurrencyIsoCode, Name, SBQQ__Active__c, SBQQ__AdvancedCondition__c, SBQQ__ConditionsMet__c, SBQQ__ConfiguratorEvaluationEvent__c, SBQQ__EvaluationEvent__c, SBQQ__EvaluationOrder__c, SBQQ__LookupObject__c, SBQQ__TargetObject__c, Key__c, Description__c FROM SBQQ__PriceRule__c",
"deleteQuery": "SELECT Id FROM SBQQ__PriceRule__c"
},
{
"operation": "Insert",
"externalId": "Id",
"mockFields": [],
"updateWithMockData": false,
"mockCSVData": false,
"deleteOldData": true,
"allRecords": true,
"useCSVValuesMapping": false,
"query": "SELECT Id, SBQQ__FooterContent__c, SBQQ__HeaderContent__c, CurrencyIsoCode, Name, SBQQ__AllPackageProductsShown__c, SBQQ__BillToTitle__c, SBQQ__BorderColor__c, SBQQ__BottomMargin__c, SBQQ__BundledProductsShown__c, SBQQ__CompanyCity__c, SBQQ__CompanyCountry__c, SBQQ__CompanyEmail__c, SBQQ__CompanyFax__c, SBQQ__CompanyName__c, SBQQ__CompanyPhone__c, SBQQ__CompanyPostalCode__c, SBQQ__CompanySlogan__c, SBQQ__CompanyState__c, SBQQ__CompanyStreet__c, SBQQ__ComponentProductsHidden__c, SBQQ__CustomerDiscountField__c, SBQQ__CustomerDiscountLabel__c, SBQQ__CustomerDiscountShown__c, SBQQ__Default__c, SBQQ__DeploymentStatus__c, SBQQ__DiscountScheduleShown__c, SBQQ__ExcludeHeaderFooter__c, SBQQ__ExcludedPages__c, SBQQ__FontFamily__c, SBQQ__FontSize__c, SBQQ__FooterHeight__c, SBQQ__GeneratorName__c, SBQQ__GrandTotalPrefix__c, SBQQ__GroupField__c, SBQQ__GroupFontFamily__c, SBQQ__GroupFontSize__c, SBQQ__GroupFontStyle__c, SBQQ__GroupGap__c, SBQQ__GroupShadingColor__c, SBQQ__GroupTextAlignment__c, SBQQ__GroupTextColor__c, SBQQ__HeaderHeight__c, SBQQ__HideGroupSubtotals__c, SBQQ__IntroductionTitle__c, SBQQ__LeftMargin__c, SBQQ__LineNumbering__c, SBQQ__LineSortField__c, SBQQ__LogoDocumentId__c, SBQQ__NotesTitle__c, SBQQ__PageHeight__c, SBQQ__PageNumberAlignment__c, SBQQ__PageNumberPosition__c, SBQQ__PageNumberText__c, SBQQ__PageOrientation__c, SBQQ__PageWidth__c, SBQQ__PartnerDiscountLabel__c, SBQQ__PartnerDiscountShown__c, SBQQ__RenewedProductsShown__c, SBQQ__RightMargin__c, SBQQ__RollUpField__c, SBQQ__ShadingColor__c, SBQQ__ShipToTitle__c, SBQQ__SubGroupField__c, SBQQ__SubtotalField__c, SBQQ__SubtotalLabel__c, SBQQ__TermBodyIndent__c, SBQQ__TermsConditionsTitle__c, SBQQ__TermsConditions__c, SBQQ__TermsNumbered__c, SBQQ__TextColor__c, SBQQ__TopMargin__c, SBQQ__TotalField__c, SBQQ__TotalLabel__c, SBQQ__TotalsHidden__c, SBQQ__WatermarkId__c, GlobalLogo__c, Key__c, QuoteTemplateSelector__c FROM SBQQ__QuoteTemplate__c",
"deleteQuery": "SELECT Id FROM SBQQ__QuoteTemplate__c"
},
{
"operation": "Insert",
"externalId": "Id",
"mockFields": [],
"updateWithMockData": false,
"mockCSVData": false,
"deleteOldData": true,
"allRecords": true,
"useCSVValuesMapping": false,
"query": "SELECT Id, SBQQ__Action__c, CurrencyIsoCode, Name, SBQQ__DisplayOrder__c, SBQQ__FilterSourceField__c, SBQQ__FilterSourceObject__c, SBQQ__FilterValue__c, SBQQ__HiddenSourceField__c, SBQQ__HiddenSourceObject__c, SBQQ__Hidden__c, SBQQ__Operator__c, SBQQ__TargetField__c, SBQQ__TargetObject__c FROM SBQQ__SearchFilter__c",
"deleteQuery": "SELECT Id FROM SBQQ__SearchFilter__c"
},
{
"operation": "Insert",
"externalId": "Id",
"mockFields": [],
"updateWithMockData": false,
"mockCSVData": false,
"deleteOldData": true,
"allRecords": true,
"useCSVValuesMapping": false,
"query": "SELECT Id, SBQQ__Localization__c, CurrencyIsoCode, Name, SBQQ__Value__c FROM SBQQ__SearchIndex__c",
"deleteQuery": "SELECT Id FROM SBQQ__SearchIndex__c"
},
{
"operation": "Insert",
"externalId": "Id",
"mockFields": [],
"updateWithMockData": false,
"mockCSVData": false,
"deleteOldData": true,
"allRecords": true,
"useCSVValuesMapping": false,
"query": "SELECT Id, CurrencyIsoCode, Name, SBQQ__CustomSource__c, SBQQ__FontFamily__c, SBQQ__FontSize__c, SBQQ__Markup__c, SBQQ__RawMarkup__c, SBQQ__TableStyle__c, SBQQ__TextColor__c, SBQQ__Type__c, Key__c FROM SBQQ__TemplateContent__c",
"deleteQuery": "SELECT Id FROM SBQQ__TemplateContent__c"
},
{
"operation": "Upsert",
"externalId": "Name",
"mockFields": [],
"updateWithMockData": false,
"mockCSVData": false,
"deleteOldData": false,
"allRecords": true,
"useCSVValuesMapping": false,
"query": "SELECT Id, CurrencyIsoCode, Name, SBQQ__Template__c, SBQQ__BorderColor__c, SBQQ__BottomMargin__c, SBQQ__ColumnHeaderHidden__c, SBQQ__ConditionalPrintField__c, SBQQ__DisplayOrder__c, SBQQ__FilterField__c, SBQQ__FilterOperator__c, SBQQ__FilterValue__c, SBQQ__GroupField__c, SBQQ__KeepTogether__c, SBQQ__KeepWithNext__c, SBQQ__KeepWithPrevious__c, SBQQ__PageBreak__c, SBQQ__QuoteTotalsPrinted__c, SBQQ__RollUpField__c, SBQQ__SummaryDisplay__c, SBQQ__TopMargin__c, Key__c, SBQQ__Content__c FROM SBQQ__TemplateSection__c",
"deleteQuery": ""
},
{
"operation": "Insert",
"externalId": "Id",
"mockFields": [],
"updateWithMockData": false,
"mockCSVData": false,
"deleteOldData": true,
"allRecords": true,
"useCSVValuesMapping": false,
"query": "SELECT Id, RecordTypeId, SBQQ__Feature__c, SBQQ__Product__c, CurrencyIsoCode, Name, SBQQ__AppliedImmediately__c, SBQQ__ApplyToProductOptions__c, SBQQ__AutoSelect__c, SBQQ__ColumnOrder__c, SBQQ__DefaultField__c, SBQQ__DefaultObject__c, SBQQ__DisplayOrder__c, SBQQ__HiddenValues__c, SBQQ__Hidden__c, SBQQ__Position__c, SBQQ__Required__c, SBQQ__ShownValues__c, SBQQ__TargetField__c FROM SBQQ__ConfigurationAttribute__c",
"deleteQuery": "SELECT Id FROM SBQQ__ConfigurationAttribute__c"
},
{
"operation": "Insert",
"externalId": "Id",
"mockFields": [],
"updateWithMockData": false,
"mockCSVData": false,
"deleteOldData": true,
"allRecords": true,
"useCSVValuesMapping": false,
"query": "SELECT Id, SBQQ__LineColumn__c, SBQQ__PriceDimension__c, SBQQ__ProductFeature__c, SBQQ__ProductOption__c, SBQQ__Product__c, SBQQ__QuoteTemplate__c, SBQQ__QuoteTerm__c, SBQQ__TemplateContent__c, CurrencyIsoCode, Name, SBQQ__APIName__c, SBQQ__Description__c, SBQQ__Label__c, SBQQ__Language__c, SBQQ__LongTextArea__c, SBQQ__RichTextArea__c, SBQQ__TextArea__c, SBQQ__Text__c, SBQQ__UserDefined__c FROM SBQQ__Localization__c",
"deleteQuery": "SELECT Id FROM SBQQ__Localization__c"
},
{
"operation": "Insert",
"externalId": "Id",
"mockFields": [],
"updateWithMockData": false,
"mockCSVData": false,
"deleteOldData": true,
"allRecords": true,
"useCSVValuesMapping": false,
"query": "SELECT Id, CurrencyIsoCode, Name, SBQQ__Active__c, SBQQ__AdvancedCondition__c, SBQQ__ConditionsMet__c, SBQQ__ErrorMessage__c, SBQQ__EvaluationEvent__c, SBQQ__EvaluationOrder__c, SBQQ__LookupMessageField__c, SBQQ__LookupObject__c, SBQQ__LookupProductField__c, SBQQ__LookupRequiredField__c, SBQQ__LookupTypeField__c, SBQQ__Scope__c, SBQQ__Type__c FROM SBQQ__ProductRule__c",
"deleteQuery": "SELECT Id FROM SBQQ__ProductRule__c"
},
{
"operation": "Insert",
"externalId": "Id",
"mockFields": [],
"updateWithMockData": false,
"mockCSVData": false,
"deleteOldData": true,
"allRecords": true,
"useCSVValuesMapping": false,
"query": "SELECT Id, SBQQ__CombineWith__c, CurrencyIsoCode, Name, SBQQ__AggregateField__c, SBQQ__AggregateFunction__c, SBQQ__CompositeOperator__c, SBQQ__ConstraintField__c, SBQQ__FilterField__c, SBQQ__FilterValue__c, SBQQ__Operator__c, SBQQ__Scope__c, SBQQ__TargetObject__c, SBQQ__ValueElement__c FROM SBQQ__SummaryVariable__c",
"deleteQuery": "SELECT Id FROM SBQQ__SummaryVariable__c"
},
{
"operation": "Readonly",
"externalId": "DeveloperName",
"mockFields": [],
"updateWithMockData": false,
"mockCSVData": false,
"deleteOldData": false,
"allRecords": true,
"useCSVValuesMapping": false,
"query": "SELECT Id, DeveloperName, SobjectType FROM RecordType",
"deleteQuery": ""
},
{
"operation": "Insert",
"externalId": "Id",
"mockFields": [],
"updateWithMockData": false,
"mockCSVData": false,
"deleteOldData": true,
"allRecords": true,
"useCSVValuesMapping": false,
"query": "SELECT Id, SBQQ__DiscountSchedule__c, SBQQ__PriceBook__c, SBQQ__Product__c, SBQQ__TermDiscountSchedule__c, CurrencyIsoCode, Name, SBQQ__CostEditable__c, SBQQ__DefaultQuantity__c, SBQQ__NonDiscountable__c, SBQQ__NonPartnerDiscountable__c, SBQQ__PriceEditable__c, SBQQ__QuantityEditable__c, SBQQ__QuantityScale__c, SBQQ__Taxable__c, SBQQ__Type__c, SBQQ__UnitPrice__c FROM SBQQ__Dimension__c",
"deleteQuery": "SELECT Id FROM SBQQ__Dimension__c"
},
{
"operation": "Insert",
"externalId": "Id",
"mockFields": [],
"updateWithMockData": false,
"mockCSVData": false,
"deleteOldData": true,
"allRecords": true,
"useCSVValuesMapping": false,
"query": "SELECT Id, Name FROM SBQQ__ProductFeature__c",
"deleteQuery": "SELECT Id FROM SBQQ__ProductFeature__c"
},
{
"operation": "Insert",
"externalId": "Id",
"mockFields": [],
"updateWithMockData": false,
"mockCSVData": false,
"deleteOldData": true,
"allRecords": true,
"useCSVValuesMapping": false,
"query": "SELECT Id, SBQQ__ConfiguredSKU__c, SBQQ__DiscountSchedule__c, SBQQ__Feature__c, SBQQ__OptionalSKU__c, SBQQ__RenewalProductOption__c, CurrencyIsoCode, Name, SBQQ__AppliedImmediatelyContext__c, SBQQ__AppliedImmediately__c, SBQQ__Bundled__c, SBQQ__ComponentCodePosition__c, SBQQ__ComponentCode__c, SBQQ__ComponentDescriptionPosition__c, SBQQ__ComponentDescription__c, SBQQ__DefaultPricingTable__c, SBQQ__DiscountAmount__c, SBQQ__Discount__c, SBQQ__DiscountedByPackage__c, SBQQ__ExistingQuantity__c, SBQQ__MaxQuantity__c, SBQQ__MinQuantity__c, SBQQ__Number__c, SBQQ__QuantityEditable__c, SBQQ__Quantity__c, SBQQ__QuoteLineVisibility__c, SBQQ__Required__c, SBQQ__Selected__c, SBQQ__SubscriptionScope__c, SBQQ__System__c, SBQQ__Type__c, SBQQ__UnitPrice__c, SBQQ__UpliftedByPackage__c FROM SBQQ__ProductOption__c",
"deleteQuery": "SELECT Id FROM SBQQ__ProductOption__c"
},
{
"operation": "Insert",
"externalId": "Id",
"mockFields": [],
"updateWithMockData": true,
"mockCSVData": false,
"deleteOldData": true,
"allRecords": true,
"useCSVValuesMapping": false,
"query": "SELECT Id, SBQQ__ParentTerm__c, SBQQ__Quote__c, SBQQ__StandardTerm__c, SBQQ__TemplateContent__c, CurrencyIsoCode, Name, SBQQ__Active__c, SBQQ__AdvancedCondition__c, SBQQ__Body__c, SBQQ__ConditionsMet__c, SBQQ__Locked__c, SBQQ__PrintOrder__c, SBQQ__Status__c, TermName__c FROM SBQQ__QuoteTerm__c",
"deleteQuery": "SELECT Id FROM SBQQ__QuoteTerm__c"
}
],
"promptOnMissingParentObjects": false,
"promptOnIssuesInCSVFiles": false,
"allOrNone": true,
"bulkApiV1BatchSize": 9500,
"bulkApiVersion": "2.0",
"createTargetCSVFiles": true,
"excludeIdsFromCSVFiles": false,
"validateCSVFilesOnly": false,
"importCSVFilesAsIs": false,
"promptOnUpdateError": false,
"pollingIntervalMs": 5000,
"bulkThreshold": 200,
"apiVersion": "47.0"
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment