/soqlgen

A simple tool that generates soql for all fields per object. Has the ability to include multi-currency function wrapping & formatting!

Primary LanguagePython

SOQL GEN

Description

A simple tool that generates soql for all fields per object in a CSV file. Has the ability to include multi-currency function wrapping & formatting!

Install

Make sure Python 3 is intalled and run the following command

macOS

./install.sh

Windows (UNTESTED - MAY NEED WORK)

./install.bat

Running

python soqlgen.py

Example Output

Account

SELECT Id, IsDeleted, MasterRecordId, Name, Type, ParentId, BillingStreet, BillingCity, BillingState,
BillingPostalCode, BillingCountry, BillingLatitude, BillingLongitude, BillingGeocodeAccuracy,
BillingAddress, ShippingStreet, ShippingCity, ShippingState, ShippingPostalCode, ShippingCountry,
ShippingLatitude, ShippingLongitude, ShippingGeocodeAccuracy, ShippingAddress, Phone, Fax, AccountNumber,
Website, PhotoUrl, Sic, Industry, FORMAT(convertCurrency(AnnualRevenue)), NumberOfEmployees, Ownership,
TickerSymbol, Description, Rating, Site, OwnerId, CreatedDate, CreatedById, LastModifiedDate,
LastModifiedById, SystemModstamp, LastActivityDate, LastViewedDate, LastReferencedDate, Jigsaw,
JigsawCompanyId, CleanStatus, AccountSource, DunsNumber, Tradestyle, NaicsCode, NaicsDesc, YearStarted,
SicDesc, DandbCompanyId, CustomerPriority__c, SLA__c, Active__c, NumberofLocations__c,
UpsellOpportunity__c, SLASerialNumber__c, SLAExpirationDate__c
FROM Account

Contact

SELECT Id, IsDeleted, MasterRecordId, AccountId, LastName, FirstName, Salutation, Name, OtherStreet,
OtherCity, OtherState, OtherPostalCode, OtherCountry, OtherLatitude, OtherLongitude,
OtherGeocodeAccuracy, OtherAddress, MailingStreet, MailingCity, MailingState, MailingPostalCode,
MailingCountry, MailingLatitude, MailingLongitude, MailingGeocodeAccuracy, MailingAddress, Phone, Fax,
MobilePhone, HomePhone, OtherPhone, AssistantPhone, ReportsToId, Email, Title, Department, AssistantName,
LeadSource, Birthdate, Description, OwnerId, CreatedDate, CreatedById, LastModifiedDate,
LastModifiedById, SystemModstamp, LastActivityDate, LastCURequestDate, LastCUUpdateDate, LastViewedDate,
LastReferencedDate, EmailBouncedReason, EmailBouncedDate, IsEmailBounced, PhotoUrl, Jigsaw,
JigsawContactId, CleanStatus, Level__c, Languages__c
FROM Contact