Devon Guerrero papagunit

name	alpha-2	alpha-3	country-code	iso_3166-2	region	sub-region	intermediate-region	region-code	sub-region-code	intermediate-region-code
Afghanistan	AF	AFG	004	ISO 3166-2:AF	Asia	Southern Asia		142	034
Åland Islands	AX	ALA	248	ISO 3166-2:AX	Europe	Northern Europe		150	154
Albania	AL	ALB	008	ISO 3166-2:AL	Europe	Southern Europe		150	039
Algeria	DZ	DZA	012	ISO 3166-2:DZ	Africa	Northern Africa		002	015
American Samoa	AS	ASM	016	ISO 3166-2:AS	Oceania	Polynesia		009	061
Andorra	AD	AND	020	ISO 3166-2:AD	Europe	Southern Europe		150	039
Angola	AO	AGO	024	ISO 3166-2:AO	Africa	Sub-Saharan Africa	Middle Africa	002	202	017
Anguilla	AI	AIA	660	ISO 3166-2:AI	Americas	Latin America and the Caribbean	Caribbean	019	419	029
Antarctica	AQ	ATA	010	ISO 3166-2:AQ

	// API documentation, https://developers.hubspot.com/docs/methods/forms/submit_form

	const convertToFormData = (data) => Object.entries(data).reduce((formData, entry) => {
	const [key, value] = entry;
	if (value !== null && typeof value === 'object') {
	formData.append(key, JSON.stringify(value));
	} else {
	formData.append(key, value);
	}
	return formData;

	// Profiles to leave enabled
	Set<String> excludedProfiles = new Set<String> {
	'System Administrator',
	'Integration System Administrator',
	'AccessTSC Digital Profile',
	'TriState Onboarding Team',
	'Tristate Administrator'
	};

	List<User> usersToUpdate = new List<User>();

	/*
	* Returns the type of a given object. This is a hack around the fact that we can't access the type of an object.
	* @param {Object} obj An object
	* @returns {Type} the type of the object
	*/
	private static Type getType(Object obj) {
	String typeName = 'Date';

	// Attempt to cast the object to Datetime
	// If it succeeds, the object is a date

	name: Selecting Ranges
	description: This code leverages different ways to select cells using the Office API.
	host: EXCEL
	api_set: {}
	script:
	content: \|
	$("#run1").click(() => tryCatch(workingWithRanges));

	async function workingWithRanges() {
	await Excel.run(async (context) => {

	/*
	* A traversable JSON data structure.
	*
	* Conceptually, JSON is a general tree, or array of general trees. It is represented in Apex using Map<String, Object>
	* for objects, List<Object> for arrays, String for strings, and either Integer or Decimal for numbers. This class wraps
	* these data types in order to provide an interface for traversiing and querying the entire JSON structure.
	*
	* Each node contains a single value that must be a valid JSON value. That is, Map<String, Object>, List<Object>,
	* String, Decimal, Integer, or null. When traversing or querying a JSON structure, any value returned is always wrapped
	* in a JsonData instance to allow subsequent traversal or query.