Go Back
Salesforce to Ellucian Ethos Writer
Publisher
: Lingk
Run In Lingk
Description
Pulls academic programs from Salesforce Education Data Architecture (EDA) Account objects and upserts them into the Ellucian Ethos Academic Levels object. To run, update the Salesforce SOQL query to point to your academic levels.
Browse the knowledge base
Twitter
E-Mail
# _____ _ _____ __ # | __ \ (_) |_ _| / _| # | |__) |___ ___ _ _ __ ___ | | _ __ | |_ ___ # | _ // _ \/ __| | '_ \ / _ \ | | | '_ \| _/ _ \ # | | \ \ __/ (__| | |_) | __/ _| |_| | | | || (_) | # |_| \_\___|\___|_| .__/ \___| |_____|_| |_|_| \___/ # | | # |_| # Project Name - SALESFORCE TO ELLUCIAN ETHOS WRITER # Recipe ID - # Recipe URL - https://app.lingk.io/a/10932/tf/17488 # Description - # Pulls academic programs from Salesforce Education Data Architecture (EDA) Account objects and upserts them into the Ellucian Ethos Academic Levels object. # To run, update the Salesforce SOQL query to point to your academic levels. # Industry - Higher Ed # Business Process - Graduate Reporting # Systems - Salesforce, Ethos # Connectors - Salesforce, Ethos # Data Flows - Single Direction # Connection Type - API to API # Data Models ## Ethos Models Used: #1. academic-levels ## Salesforce Objects Used: #1. Account # Add Recipe notes / Change log information here! # _____ _ # / ____| | | # | | ___ _ __ _ __ ___ ___| |_ ___ _ __ ___ # | | / _ \| '_ \| '_ \ / _ \/ __| __/ _ \| '__/ __| # | |___| (_) | | | | | | | __/ (__| || (_) | | \__ \ # \_____\___/|_| |_|_| |_|\___|\___|\__\___/|_| |___/ # # CONNECTORS specify what data will be pulled into the in-memory database during processing connectors: # Configure Ethos & Salesforce credentials in your Environment before running this recipe # Ethos Setup - https://help.lingk.io/en/articles/292-ellucian-ethos-connector-setup-guide # Salesforce Setup - https://help.lingk.io/en/articles/267-salesforce-connector-setup-guide ###### Start - Ethos Reader connectors ###### # Set up Ellucian Ethos credentials in your Environment before running this recipe and create an Account in SF ('SF Test') - name: academicLevelsReader type: ethosReader properties: path: /api/academic-levels dataModelVersion: 6 ###### End - Ethos Reader connectors ###### ###### Start - Ethos Writer connectors ###### # specify the dataModelVersion that aligns with the Ethos path - name: academicLevelsWriter type: ethosWriter properties: path: /api/academic-levels dataModelVersion: 6 ###### End - Ethos Writer connectors ###### ###### Start - Salesforce Reader connectors ###### # update this example to read from your academic level list - name: sfAccountReader type: salesforceReader properties: useBearerToken: true query: select ID, Name, Ethos_Id__c from Account where RecordTypeId in (Select Id From RecordType where Name = 'Academic Program') and Name = 'SF Test' schema: fields: - name: ID type: String - name: Name type: String - name: Ethos_Id__c type: String ###### End - Salesforce Reader connectors ###### # _____ _ _ _ # / ____| | | | | | # | (___ | |_ __ _| |_ ___ _ __ ___ ___ _ __ | |_ ___ # \___ \| __/ _` | __/ _ \ '_ ` _ \ / _ \ '_ \| __/ __| # ____) | || (_| | || __/ | | | | | __/ | | | |_\__ \ # |_____/ \__\__,_|\__\___|_| |_| |_|\___|_| |_|\__|___/ # STATEMENTS specify how the data should be processed while in memory statements: #******************************************************************** D I S C L A I M E R *********************************************************************************************** # * # Note that in an effort to keep recipes optimized for DPH (Data Processing Hours), print statements should be commented out after development has concluded for a recipe. * # For more information on DPH optimization, please visit the following help article - https://help.lingk.io/en/articles/212-minimizing-data-processing-hours-on-the-lingk-platform * # * #******************************************************************** D I S C L A I M E R *********************************************************************************************** # Start debugging (optional) - statement: (getLevels) => select * from academicLevelsReader #- statement: print getLevels - statement: (getLevelsCount) => select count(*) from academicLevelsReader #- statement: print getLevelsCount - statement: (getAccounts) => select * from sfAccountReader #- statement: print getAccounts - statement: (sfAccountReaderCount) => select count(*) from sfAccountReader #- statement: print sfAccountReaderCount # End debugging (optional) # Get programs to insert (matching by title and Name) # The 'LEFT ANTI JOIN' function retrieves the rows from the first table (table after the FROM statement) that do not match with the rows on the second table (right table) - statement: | (programsToInsert) => select "00000000-0000-0000-0000-000000000000" id, sfAccountReader.Name title, "bb" code from sfAccountReader left anti join academicLevelsReader on academicLevelsReader.title = sfAccountReader.Name # optional #- statement: print programsToInsert #### Start - Insert academics-level #### - statement: insert programsToInsert into academicLevelsWriter #### End - Insert academics-level #### # Add more statements to convert, join, aggregrate, transform, and integrate your data
Microsoft Dynamics CRM to SFTP
Ellucian Ethos to Salesforce Writer