Skip to content

Instantly share code, notes, and snippets.

@jsullivanlive
Last active October 18, 2017 01:57
Show Gist options
  • Save jsullivanlive/3f9ccfdc0d1716be2fdf6fb3eaab5d20 to your computer and use it in GitHub Desktop.
Save jsullivanlive/3f9ccfdc0d1716be2fdf6fb3eaab5d20 to your computer and use it in GitHub Desktop.
Compare custom report type fields between salesforce orgs
/**
** when you do an org-to-org migration it can be handy to know what
** fields are different between the orgs for a given report type
*/
const jsforce = require('jsforce')
var extend = require('util')._extend
async function run () {
var sourceConn = new jsforce.Connection({/*TODO*/})
var destConn = new jsforce.Connection({/*TODO*/})
var left = await sourceConn.requestGet('/services/data/v39.0/analytics/reportTypes/My_Report_Type__c')
var right = await destConn.requestGet('/services/data/v39.0/analytics/reportTypes/My_Report_Type__c')
var leftColumns = Object.keys(left.reportTypeMetadata.categories.reduce((a, b) => extend(a, b.columns), {}))
var rightColumns = Object.keys(right.reportTypeMetadata.categories.reduce((a, b) => extend(a, b.columns), {}))
console.log('right missing: ', leftColumns.filter(x => !rightColumns.includes(x)) )
console.log('left missing: ', rightColumns.filter(x => !leftColumns.includes(x)) )
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment