Page Comparison

• SOAP - see https://tddprojects.atlassian.net/wiki/pages/createpage.action?spaceKey=SF&title=SOAP%20vs%20REST&linkCreation=true&fromPageId=1310425107

• Note there are way more APIs than this but the exam is OLD.

Bulk API

• REST based

• AysnchronousAsynchronous

• CSV data

• Version 1 (OLD) and Version 2

• Large Data Volumes

  • For Data Migrations

• Query, Insert, Update, Upsert and Delete

• Bulk API Version 1.

  • Send csv rows to a batch

    • Stream the file to a temporary storage and return the ID

    • database operations done in 200 records chunks

    • Generate the result file

  • Create a Job

    • Send data in batches

    • check status of batches

    • retrieve the result for each batch

    • Close the job

  • Limits https://developer.salesforce.com/docs/atlas.en-us.salesforce_app_limits_cheatsheet.meta/salesforce_app_limits_cheatsheet/salesforce_app_limits_platform_bulkapi.htm

    • Max file size 10MB

    • Max No. records in a batch - 10,000 with 10,000,000 characters

    • 15 attempts

    • Max retrieved file size 1GB

  • Monitoring

    • Job ID

    • Object

    • Operation

    • Progress

    • Records Processed

    • Start Time

    • End Time (for completed)

    • Status

    • Submitted Time (for in progress)

    • Time to Complete (for completed jobs)

• Bulk API 2.0 is available in API version 41.0 and later. Query jobs in Bulk API 2.0 are available in API version 47.0 and later.

• Difference between version 1 and version 2.

  • https://developer.salesforce.com/blogs/2017/12/slim-new-bulk-api-v2.html

    • Bulk API v2 does away with the need to manually break up data into batches. Simply submit jobs with the full set of records, and Salesforce automatically determines the most efficient way to batch the data.

    • Bulk API v2 simplifies the basic daily limits. Instead of having limits based on the number of Bulk jobs and batches, you’re simply limited to a maximum number of records (100 million) per 24 hour period.

      • Note now 150 million records per day as of Summer '20

      • Maximum number of records uploaded per rolling 24-hour period

      • Files to upload have to be max 150MB AFTER Base 64 encoding.

      • The maximum number of query jobs per 24-hour rolling window is 10,000 with The total query results that can be generated per 24 hour rolling window being 1TB

      • Queries don’t use Batches

    • If the job completes but encountered errors during processing, request the complete list of failed records with one API call, determine why the records failed, and submit a new job as needed.

    • You can specify different column delimiters and line endings for your CSV data, including:

      • backquotes, carets, pipes, semi-colons, and tabs for delimiters (instead of commas)

      • carriage-return & linefeed line endings (instead of just linefeeds)

  • Salesforce creates a separate batch for every 10,000 records in your job data, up to a daily maximum of 150,000,000 records. If the limit is exceeded while processing your job data, the remaining data isn’t processed. The job is marked as having failed. Create a new job to process the records that were not processed.

  • For each internal batch, if Salesforce can’t process all the records in a batch in 10 minutes or less, the batch fails. Salesforce retries failed batches up to a maximum of 10 retries. If the batch still can’t be processed after 10 retries, the entire job is moved to the Failed state and remaining job data is not processed. Use the Failed Record Results and Unprocessed Record Results resources to determine what records were not processed and what errors occurred.

• Note there are more changes in V50 of the API, but that won’t be in the exam I’m taking

  • https://releasenotes.docs.salesforce.com/en-us/winter21/release-notes/rn_api_bulk_2.htm

• And Bulk API is available in Event Monitoring as of Winter '21

  • https://releasenotes.docs.salesforce.com/en-us/winter21/release-notes/rn_security_em_bulkapiresultevent.htm

...

• the metadata of the Org

Streaming API

...

Pub / Sub model

...

Subscribe to a channel

...

No need for polling

...

Broadcast changes

...

See Streaming, Platform Events and CDC

Email Service

• Process Contents, Headers and Attachments of Inbound Email

• Messaging.InboundEmailHandler

...