Scott McClung scottmcclung

Salesforce OAuth 2.0 JWT Bearer Token Flow Walk-Through

This document will walk you through how to create or configure a Salesforce application for use with JWT authentication. These configuration steps and the example code works as of Salesforce API version 42.0.

Prerequisites

Create an RSA x509 private key/certification pair

	--------------------------------------------------------------------
	-- Queries related to distribution of metadata.
	-- Find the number of users per profile.
	SELECT count(id), Profile.name
	FROM User
	WHERE User.IsActive = true
	GROUP BY Profile.name

	-- Find the distribution of Apex classes per namespace.
	select count(id), NameSpacePrefix

	FROM revgum/lucky
	RUN mkdir /data
	WORKDIR /data
	ADD . /data
	EXPOSE 5000

	<?php

	namespace App\Traits;

	use Rhumsaa\Uuid\Uuid;
	use Illuminate\Database\Eloquent\ModelNotFoundException;

	/**
	* Trait UuidModel
	* @package App\Traits

	if (
	and (
	YEAR(Date_Start__c) == YEAR(TODAY()),

	IF(
	CEILING( ( Date_Start__c - DATE( YEAR( Date_Start__c ), 1, 1) + 1) / 7) > 52,
	52,
	CEILING( ( Date_Start__c - DATE( YEAR( Date_Start__c ), 1, 1) + 1) / 7)
	) ==
	IF(

	/**
	* Connect and fetch Salesforce data via OAuth
	*/
	function queryDataFromSalesforce() {
	// Read OAuth consumer key / secret of this client app from script properties,
	// which can be issued from Salesforce's remote access setting in advance.
	var sfConsumerKey = ScriptProperties.getProperty("sfConsumerKey");
	var sfConsumerSecret = ScriptProperties.getProperty("sfConsumerSecret");
	if (!sfConsumerKey \|\| !sfConsumerSecret) {
	Browser.msgBox("Register Salesforce OAuth Consumer Key and Secret in Script Properties");

	install PostgreSQL 9 in Mac OSX via Homebrew


	Mac OS X Snow Leopard
	System Version: Mac OS X 10.6.5
	Kernel Version: Darwin 10.5.0


	Install notes for PostgreSQL 9.0.1 install using Homebrew:
	sh-3.2# brew install postgresql