Trailhead module – Lightning Platform API Basics – Import Accounts Using Bulk API and Workbench

Unlike other modules where I was writing the debug instructions to work around the issue with validation, this one is more of a guidance type. Instructions for this module isn’t due to any issues from the Trailhead validation side, but rather a tip of how to get it quickly.

 

  1. ISSUE/ Step: Use Bulk API writing the request

 The module itself is a walkthrough, to accomplish the challenge you just need to follow the same steps with the exception of the request body

The steps to folow are the same as those specified in the module example: 
1. Import the account records provided via these account records and save in csv format
2. Log into workbench and with your dev org
3. In REST explorer create a job 
    HTTP method POST
    URI textbox:  /services/data/vXX.0/jobs/ingest  (make sure to put the right API version on the XX)   

   Request header text:
Content-Type: application/json; charset=UTF-8
Accept: application/json
    Request body text: 
{
“operation” : “insert”,
“object” : “Account”,
“contentType” : “CSV”,
“lineEnding” : “CRLF”
}
4. Execute
5. Copy the job ID
6. Add the data to the job;
 HTTP method PUT
    URI textbox:  /services/data/vXX.0/jobs/ingest/7500XXXXXXXXXXXXX/batches (Make sure to replace the Job ID)

DEBUG

The main things that needs to be done is appending the file with the inverted commas so that you can send the request

If you want to get append your excel skills, here how to do it here:

  1. Highlight the cells you want to add the quotes.
  2. Go to Format –> Cells –> Custom.
  3. Copy/Paste the following into the Type field: \”@\”
  4. Click “okay”

Or you can just copy paste the Request Content in the end of this article

7. Execute
8. Close the job
 HTTP method PATCH
    URI textbox: /services/data/vXX.0/jobs/ingest/7500XXXXXXXXXXXXX (Make sure to replace the Job ID)
 

  Request header text:
Content-Type: application/json; charset=UTF-8
Accept: application/json

  Request body text:

{
“state” : “UploadComplete”
}

9. Execute

10. Check the results

 HTTP method GET
    URI textbox: /services/data/vXX.0/jobs/ingest/7500XXXXXXXXXXXXX/successfulResults (Make sure to replace the Job ID)

Should have the full list of the 500 Accounts (you can also check the Accounts tab via Salesforce UI)

 HTTP method GET
    URI textbox: /services/data/vXX.0/jobs/ingest/7500XXXXXXXXXXXXX/failedResults (Make sure to replace the Job ID)

This one should have 0 lines below “sf__Id”,”sf__Error”,”Name”

Check the challenge

That’s it, one more step to go before the new badge 😉

REQUEST CONTENT

Request Headers:
Content-Type: text/csv
Accept: application/json 

Request body text:
"Name"
"Insuron Bulk Company"
"Orboid Bulk Company"
"Bovis Bulk Company"
"Roughies Bulk Company"
"Otherside Bulk Company"
"Endipin Bulk Company"
"Austech Bulk Company"
"Quility Bulk Company"
"Bleendot Bulk Company"
"Apex Bulk Company"
"Cognicode Bulk Company"
"Securia Bulk Company"
"Fanfare Bulk Company"
"Obones Bulk Company"
"Eyeris Bulk Company"
"Techtrix Bulk Company"
"Ceprene Bulk Company"
"Vortexaco Bulk Company"
"Techmania Bulk Company"
"Gleamink Bulk Company"
"Apextri Bulk Company"
"Orbalix Bulk Company"
"Zentry Bulk Company"
"Inear Bulk Company"
"Genesynk Bulk Company"
"Flum Bulk Company"
"Yogasm Bulk Company"
"Mangelica Bulk Company"
"Exoplode Bulk Company"
"Digigene Bulk Company"
"Zanymax Bulk Company"
"Imperium Bulk Company"
"Ozean Bulk Company"
"Emtrak Bulk Company"
"Evidends Bulk Company"
"Helixo Bulk Company"
"Savvy Bulk Company"
"Utara Bulk Company"
"Bolax Bulk Company"
"Lumbrex Bulk Company"
"Extragen Bulk Company"
"Aeora Bulk Company"
"Shadease Bulk Company"
"Schoolio Bulk Company"
"Zensure Bulk Company"
"Geoform Bulk Company"
"Progenex Bulk Company"
"Pathways Bulk Company"
"Avenetro Bulk Company"
"Glasstep Bulk Company"
"Irack Bulk Company"
"Isologica Bulk Company"
"Lyria Bulk Company"
"Datacator Bulk Company"
"Applideck Bulk Company"
"Kozgene Bulk Company"
"Nitracyr Bulk Company"
"Asimiline Bulk Company"
"Cuizine Bulk Company"
"Geoforma Bulk Company"
"Talkalot Bulk Company"
"Xerex Bulk Company"
"Glukgluk Bulk Company"
"Stralum Bulk Company"
"Quantasis Bulk Company"
"Luxuria Bulk Company"
"Xsports Bulk Company"
"Multiflex Bulk Company"
"Hinway Bulk Company"
"Renovize Bulk Company"
"Tripsch Bulk Company"
"Gushkool Bulk Company"
"Reversus Bulk Company"
"Zillacon Bulk Company"
"Uberlux Bulk Company"
"Accupharm Bulk Company"
"Terrago Bulk Company"
"Idealis Bulk Company"
"Combogene Bulk Company"
"Corepan Bulk Company"
"Extragene Bulk Company"
"Exodoc Bulk Company"
"Isis Bulk Company"
"Halap Bulk Company"
"Quizka Bulk Company"
"Isoternia Bulk Company"
"Biolive Bulk Company"
"Pearlessa Bulk Company"
"Digitalus Bulk Company"
"Candecor Bulk Company"
"Uni Bulk Company"
"Opticon Bulk Company"
"Kidgrease Bulk Company"
"Parleynet Bulk Company"
"Plexia Bulk Company"
"Zytrac Bulk Company"
"Kyaguru Bulk Company"
"Beadzza Bulk Company"
"Repetwire Bulk Company"
"Snips Bulk Company"
"Virva Bulk Company"
"Zilidium Bulk Company"
"Gonkle Bulk Company"
"Infotrips Bulk Company"
"Eventage Bulk Company"
"Incubus Bulk Company"
"Idetica Bulk Company"
"Genekom Bulk Company"
"Bedder Bulk Company"
"Zanity Bulk Company"
"Eweville Bulk Company"
"Aquacine Bulk Company"
"Emtrac Bulk Company"
"Aquafire Bulk Company"
"Qualitern Bulk Company"
"Cosmetex Bulk Company"
"Zolar Bulk Company"
"Biflex Bulk Company"
"Bleeko Bulk Company"
"Illumity Bulk Company"
"Fangold Bulk Company"
"Oatfarm Bulk Company"
"Proxsoft Bulk Company"
"Isologia Bulk Company"
"Liquicom Bulk Company"
"Mitroc Bulk Company"
"Playce Bulk Company"
"Boilicon Bulk Company"
"Hydrocom Bulk Company"
"Rameon Bulk Company"
"Sustenza Bulk Company"
"Retrack Bulk Company"
"Fleetmix Bulk Company"
"Cofine Bulk Company"
"Nikuda Bulk Company"
"Dognost Bulk Company"
"Webiotic Bulk Company"
"Quizmo Bulk Company"
"Indexia Bulk Company"
"Centregy Bulk Company"
"Lexicondo Bulk Company"
"Ramjob Bulk Company"
"Junipoor Bulk Company"
"Oronoko Bulk Company"
"Pawnagra Bulk Company"
"Furnigeer Bulk Company"
"Sealoud Bulk Company"
"Waterbaby Bulk Company"
"Velos Bulk Company"
"Supportal Bulk Company"
"Hopeli Bulk Company"
"Combogen Bulk Company"
"Puria Bulk Company"
"Deepends Bulk Company"
"Makingway Bulk Company"
"Isotrack Bulk Company"
"Zaya Bulk Company"
"Musix Bulk Company"
"Accusage Bulk Company"
"Exostream Bulk Company"
"Furnafix Bulk Company"
"Kineticut Bulk Company"
"Arctiq Bulk Company"
"Dentrex Bulk Company"
"Grainspot Bulk Company"
"Skybold Bulk Company"
"Cosmosis Bulk Company"
"Imkan Bulk Company"
"Geofarm Bulk Company"
"Eargo Bulk Company"
"Accidency Bulk Company"
"Vendblend Bulk Company"
"Assurity Bulk Company"
"Quarmony Bulk Company"
"Medifax Bulk Company"
"Peticular Bulk Company"
"Krog Bulk Company"
"Qot Bulk Company"
"Zoxy Bulk Company"
"Aquoavo Bulk Company"
"Shopabout Bulk Company"
"Imaginart Bulk Company"
"Hatology Bulk Company"
"Visualix Bulk Company"
"Telequiet Bulk Company"
"Steelfab Bulk Company"
"Magnemo Bulk Company"
"Anocha Bulk Company"
"Earthmark Bulk Company"
"Centuria Bulk Company"
"Centrexin Bulk Company"
"Sunclipse Bulk Company"
"Jasper Bulk Company"
"Mazuda Bulk Company"
"Ginkogene Bulk Company"
"Verton Bulk Company"
"Toyletry Bulk Company"
"Corpulse Bulk Company"
"Freakin Bulk Company"
"Accufarm Bulk Company"
"Portalis Bulk Company"
"Blurrybus Bulk Company"
"Remold Bulk Company"
"Panzent Bulk Company"
"Pyrami Bulk Company"
"Assitia Bulk Company"
"Speedbolt Bulk Company"
"Ecratic Bulk Company"
"Surelogic Bulk Company"
"Buzzmaker Bulk Company"
"Scentric Bulk Company"
"Sentia Bulk Company"
"Nurplex Bulk Company"
"Kyagoro Bulk Company"
"Acumentor Bulk Company"
"Unia Bulk Company"
"Applidec Bulk Company"
"Geeky Bulk Company"
"Insource Bulk Company"
"Typhonica Bulk Company"
"Namebox Bulk Company"
"Rockabye Bulk Company"
"Zaj Bulk Company"
"Portaline Bulk Company"
"Elpro Bulk Company"
"Isonus Bulk Company"
"Xylar Bulk Company"
"Medalert Bulk Company"
"Portico Bulk Company"
"Aclima Bulk Company"
"Menbrain Bulk Company"
"Idego Bulk Company"
"Elemantra Bulk Company"
"Netplode Bulk Company"
"Plasmosis Bulk Company"
"Balooba Bulk Company"
"Obliq Bulk Company"
"Caxt Bulk Company"
"Dancity Bulk Company"
"Comtrak Bulk Company"
"Honotron Bulk Company"
"Xoggle Bulk Company"
"Zaggle Bulk Company"
"Miraclis Bulk Company"
"Acusage Bulk Company"
"Slax Bulk Company"
"Medesign Bulk Company"
"Ecrater Bulk Company"
"Orbixtar Bulk Company"
"Keeg Bulk Company"
"Virxo Bulk Company"
"Firewax Bulk Company"
"Comtrek Bulk Company"
"Geekwagon Bulk Company"
"Isologics Bulk Company"
"Omnigog Bulk Company"
"Kongene Bulk Company"
"Magnina Bulk Company"
"Koffee Bulk Company"
"Isostream Bulk Company"
"Comvey Bulk Company"
"Kindaloo Bulk Company"
"Intrawear Bulk Company"
"Exovent Bulk Company"
"Dogtown Bulk Company"
"Ultrasure Bulk Company"
"Kengen Bulk Company"
"Rodeomad Bulk Company"
"Confrenzy Bulk Company"
"Isbol Bulk Company"
"Lingoage Bulk Company"
"Tourmania Bulk Company"
"Filodyne Bulk Company"
"Mobildata Bulk Company"
"Bostonic Bulk Company"
"Niquent Bulk Company"
"Frenex Bulk Company"
"Unq Bulk Company"
"Greeker Bulk Company"
"Knowlysis Bulk Company"
"Enormo Bulk Company"
"Ecraze Bulk Company"
"Dreamia Bulk Company"
"Viagrand Bulk Company"
"Slofast Bulk Company"
"Genmex Bulk Company"
"Teraprene Bulk Company"
"Xelegyl Bulk Company"
"Zerbina Bulk Company"
"Barkarama Bulk Company"
"Miracula Bulk Company"
"Zipak Bulk Company"
"Zentility Bulk Company"
"Ovium Bulk Company"
"Zorromop Bulk Company"
"Tasmania Bulk Company"
"Pheast Bulk Company"
"Translink Bulk Company"
"Quilm Bulk Company"
"Brainclip Bulk Company"
"Steeltab Bulk Company"
"Zilencio Bulk Company"
"Buzzopia Bulk Company"
"Codact Bulk Company"
"Homelux Bulk Company"
"Exposa Bulk Company"
"Synkgen Bulk Company"
"Insuresys Bulk Company"
"Softmicro Bulk Company"
"Harmoney Bulk Company"
"Spacewax Bulk Company"
"Proflex Bulk Company"
"Paprikut Bulk Company"
"Hyplex Bulk Company"
"Qimonk Bulk Company"
"Daido Bulk Company"
"Cedward Bulk Company"
"Interodeo Bulk Company"
"Conferia Bulk Company"
"Kinetica Bulk Company"
"Dragbot Bulk Company"
"Geekola Bulk Company"
"Envire Bulk Company"
"Isotronic Bulk Company"
"Kage Bulk Company"
"Neteria Bulk Company"
"Zoarere Bulk Company"
"Qualitex Bulk Company"
"Coash Bulk Company"
"Bedlam Bulk Company"
"Multron Bulk Company"
"Zentury Bulk Company"
"Pulze Bulk Company"
"Geostele Bulk Company"
"Vixo Bulk Company"
"Podunk Bulk Company"
"Kidstock Bulk Company"
"Jetsilk Bulk Company"
"Quinex Bulk Company"
"Pivitol Bulk Company"
"Extremo Bulk Company"
"Equicom Bulk Company"
"Zizzle Bulk Company"
"Vurbo Bulk Company"
"Viagreat Bulk Company"
"Gynko Bulk Company"
"Geekmosis Bulk Company"
"Octocore Bulk Company"
"Brainquil Bulk Company"
"Kegular Bulk Company"
"Quailcom Bulk Company"
"Comvoy Bulk Company"
"Overfork Bulk Company"
"Manglo Bulk Company"
"Xinware Bulk Company"
"Cincyr Bulk Company"
"Vetron Bulk Company"
"Endicil Bulk Company"
"Sulfax Bulk Company"
"Straloy Bulk Company"
"Ohmnet Bulk Company"
"Zenthall Bulk Company"
"Edecine Bulk Company"
"Realmo Bulk Company"
"Norali Bulk Company"
"Medicroix Bulk Company"
"Digique Bulk Company"
"Tetak Bulk Company"
"Ecosys Bulk Company"
"Zilch Bulk Company"
"Scenty Bulk Company"
"Manufact Bulk Company"
"Ecolight Bulk Company"
"Utarian Bulk Company"
"Macronaut Bulk Company"
"Gracker Bulk Company"
"Geekular Bulk Company"
"Enquility Bulk Company"
"Moreganic Bulk Company"
"Powernet Bulk Company"
"Ersum Bulk Company"
"Letpro Bulk Company"
"Xeronk Bulk Company"
"Xiix Bulk Company"
"Earthpure Bulk Company"
"Gology Bulk Company"
"Sonique Bulk Company"
"Bitrex Bulk Company"
"Navir Bulk Company"
"Suremax Bulk Company"
"Ronelon Bulk Company"
"Phormula Bulk Company"
"Slumberia Bulk Company"
"Zaggles Bulk Company"
"Pholio Bulk Company"
"Comstar Bulk Company"
"Blanet Bulk Company"
"Exospace Bulk Company"
"Chorizon Bulk Company"
"Circum Bulk Company"
"Mixers Bulk Company"
"Plutorque Bulk Company"
"Recrisys Bulk Company"
"Wrapture Bulk Company"
"Rotodyne Bulk Company"
"Darwinium Bulk Company"
"Musaphics Bulk Company"
"Fitcore Bulk Company"
"Dyno Bulk Company"
"Nebulean Bulk Company"
"Twiggery Bulk Company"
"Gorganic Bulk Company"
"Volax Bulk Company"
"Immunics Bulk Company"
"Opticall Bulk Company"
"Maximind Bulk Company"
"Entogrok Bulk Company"
"Zolarex Bulk Company"
"Sureplex Bulk Company"
"Medcom Bulk Company"
"Malathion Bulk Company"
"Geekus Bulk Company"
"Emoltra Bulk Company"
"Optyk Bulk Company"
"Pyramia Bulk Company"
"Realysis Bulk Company"
"Anarco Bulk Company"
"Exozent Bulk Company"
"Digirang Bulk Company"
"Talae Bulk Company"
"Aquasseur Bulk Company"
"Frosnex Bulk Company"
"Exiand Bulk Company"
"Zillar Bulk Company"
"Medmex Bulk Company"
"Apexia Bulk Company"
"Everest Bulk Company"
"Dymi Bulk Company"
"Anacho Bulk Company"
"Protodyne Bulk Company"
"Anivet Bulk Company"
"Furnitech Bulk Company"
"Snowpoke Bulk Company"
"Prowaste Bulk Company"
"Venoflex Bulk Company"
"Fossiel Bulk Company"
"Atomica Bulk Company"
"Deviltoe Bulk Company"
"Concility Bulk Company"
"Bittor Bulk Company"
"Pushcart Bulk Company"
"Tubesys Bulk Company"
"Exospeed Bulk Company"
"Kaggle Bulk Company"
"Datagen Bulk Company"
"Trollery Bulk Company"
"Cinaster Bulk Company"
"Zillan Bulk Company"
"Franscene Bulk Company"
"Poshome Bulk Company"
"Stockpost Bulk Company"
"Velity Bulk Company"
"Prosure Bulk Company"
"Zoinage Bulk Company"
"Stucco Bulk Company"
"Zilodyne Bulk Company"
"Zytrax Bulk Company"
"Nspire Bulk Company"
"Interfind Bulk Company"
"Marqet Bulk Company"
"Recritube Bulk Company"
"Soprano Bulk Company"
"Zaphire Bulk Company"
"Techade Bulk Company"
"Remotion Bulk Company"
"Kiosk Bulk Company"
"Gogol Bulk Company"
"Zentime Bulk Company"
"Escenta Bulk Company"
"Insectus Bulk Company"
"Tri@Tribalog Bulk Company"
"Egypto Bulk Company"
"Corecom Bulk Company"
"Eplode Bulk Company"
"Comvene Bulk Company"
"Netplax Bulk Company"
"Turnling Bulk Company"
"Eventex Bulk Company"
"Izzby Bulk Company"
"Codax Bulk Company"
"Imageflow Bulk Company"
"Gadtron Bulk Company"
"Quiltigen Bulk Company"
"Roboid Bulk Company"
"Jamnation Bulk Company"
"Mantro Bulk Company"
"Futuris Bulk Company"
"Extrawear Bulk Company"
"Zappix Bulk Company"
"Voipa Bulk Company"

If you get any other issues on the way or can’t debug the above mentioned, drop me a note below.

2 Replies to “Trailhead module – Lightning Platform API Basics – Import Accounts Using Bulk API and Workbench”

  1. Venkatramana Kapavari says: Reply

    Really Fantastic Explanation Thanks a lot

    1. Thanks a lot for the feedback, I much appreciate it 🙂 Happy to help!

Leave a Reply