Get Record Types for Scratch Org Data Load

load-data.sh

#!/bin/sh

mkdir tmp

# get all record types and save to a file
sfdx force:data:soql:query --query "SELECT ID, DeveloperName, SObjectType FROM RecordType WHERE IsActive = true" > tmp/recordtypes.txt

# get record type id for account record type with developer name = Educational_Institution
RTID_ACCOUNT_INSTITUTION=`cat tmp/recordtypes.txt | awk ' $3 ~ /Account/ && $2 ~ /Educational_Institution/ { print $1 } ' `

# search and replace record types in csv
cp sample-data/institutions.csv tmp/institutions.csv
sed -i '' "s/Educational_Institution_RT/$RTID_ACCOUNT_INSTITUTION/g" tmp/institutions.csv

# upsert csv
sfdx force:data:bulk:upsert -u hedaScratch -s Account -f ./tmp/institutions.csv -i External_Id__c -w 5