# _____ _ _____ __ # | __ \ (_) |_ _| / _| # | |__) |___ ___ _ _ __ ___ | | _ __ | |_ ___ # | _ // _ \/ __| | '_ \ / _ \ | | | '_ \| _/ _ \ # | | \ \ __/ (__| | |_) | __/ _| |_| | | | || (_) | # |_| \_\___|\___|_| .__/ \___| |_____|_| |_|_| \___/ # | | # |_| # Project Name - CALIPER EVENT DATA PROCESSOR # Recipe URL - https://app.lingk.io/a/10932/tf/17834 # Description - # This recipe uses a static JSON Caliper event with nested JSON-LD and represents how easy it is to flatten the data for additional processing. This recipe can be converted to a Streaming recipe by changing the type of the connectors. # To get started, just run the recipe. No additonal configuration is required. # Industry - Higher Ed # Business Process - Graduate Reporting # Systems - Caliper # Connectors - JSON # Data Flows - Single Direction # Connection Type - JSON # Add Recipe notes / Change log information here! # _____ _ # / ____| | | # | | ___ _ __ _ __ ___ ___| |_ ___ _ __ ___ # | | / _ \| '_ \| '_ \ / _ \/ __| __/ _ \| '__/ __| # | |___| (_) | | | | | | | __/ (__| || (_) | | \__ \ # \_____\___/|_| |_|_| |_|\___|\___|\__\___/|_| |___/ # # CONNECTORS specify what data will be pulled into the in-memory database during processing connectors: # JSON Setup - https://help.lingk.io/en/articles/74-json-connector-reference ###### Start: JSON Connectors ####### - name: caliperEvent type: json properties: jsonObject: > { "@context": "http://purl.imsglobal.org/ctx/caliper/v1p1", "id": "urn:uuid:xxxxxxx-6e80-4725-94ac-50103d6780c0", "type": "GradeEvent", "actor": { "id": "urn:instructure:canvas:user:xxxx", "type": "Person" }, "action": "Graded", "object": { "id": "urn:instructure:canvas:submission:xxx", "type": "Attempt", "extensions": { "com.instructure.canvas": { "grade": "6", "entity_id": "xxx" } }, "assignee": { "id": "urn:instructure:canvas:user:xxx", "type": "Person" }, "assignable": { "id": "urn:instructure:canvas:assignment:xxx", "type": "AssignableDigitalResource" } }, "eventTime": "2017-09-26T19:01:31.000Z", "generated": { "id": "urn:instructure:canvas:submission:xxx", "type": "Score", "extensions": { "com.instructure.canvas": { "grade": "6", "entity_id": "xxx" } }, "attempt": { "id": "urn:instructure:canvas:submission:xxx", "type": "Attempt", "extensions": { "com.instructure.canvas": { "grade": "6" } }, "assignee": { "id": "urn:instructure:canvas:user:xxx", "type": "Person" }, "assignable": { "id": "urn:instructure:canvas:assignment:xxx", "type": "AssignableDigitalResource" } }, "maxScore": { "numberStr": "10.0" }, "scoreGiven": { "numberStr": "6.0" }, "scoredBy": "urn:instructure:canvas:user:xxx" }, "edApp": { "id": "http://host.instructure.com/", "type": "SoftwareApplication" }, "group": { "id": "urn:instructure:canvas:course:xxx", "type": "CourseOffering", "extensions": { "com.instructure.canvas": { "context_type": "Course", "entity_id": "xxx" } } }, "membership": { "id": "urn:instructure:canvas:course:xxx:user:xxx", "type": "Membership", "member": { "id": "urn:instructure:canvas:user:xxx", "type": "Person" }, "organization": { "id": "urn:instructure:canvas:course:xxx", "type": "CourseOffering" } }, "session": { "id": "urn:instructure:canvas:session:xxx", "type": "Session" }, "extensions": { "com.instructure.canvas": { "hostname": "hostname.instructure.com", "request_id": "xxxxxxx-c001-4be1-8c17-ac24e1eeeb6f", "user_agent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/604.1.38 (KHTML, like Gecko) Version/11.0 Safari/604.1.38", "version": "1.0.0" } } } ###### End: JSON 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 *********************************************************************************************** - statement: | (eventData) => select actor.id actorId, group.extensions.`com.instructure.canvas`.entity_id courseId from caliperEvent #- statement: print eventData # Add more statements to convert, join, aggregrate, transform, and integrate your data