Alteryx Macro Integration Guide

Inputs from Alteryx

Input #1: Meta (single row)

Field	Type	Required	Description
student_id	string	Yes	Unique student identifier.
assignment_id	string	Yes	Assignment key, e.g., A1.
problem_id	string	Yes	Problem key within the assignment, e.g., P1.

Input #2: Student submission (table)

The macro turns your table into JSON of the form:

{

  "columns": ["product_id", "total_sales"],

  "rows": [

    {"product_id": "A101", "total_sales": 1200.50},

    {"product_id": "A102", "total_sales": 980.00}

  ]

}

API Endpoint

POST

https://www.byuaccounting.net/grader/evaluate?format=json

Content-Type: application/json

Request Body

{

  "student_id": "S123",

  "assignment_id": "A1",

  "problem_id": "P1",

  "submission": {

    "columns": ["product_id","total_sales"],

    "rows": [

      {"product_id":"A101","total_sales":1200.50},

      {"product_id":"A102","total_sales":980.00}

    ]

  }

}

Rubric Options

Set on each official solution’s rubric_json:

Key	Type	Default	Description
order_matters	bool	false	If true, row order must match to avoid a sort penalty.
numeric_tolerance_abs	number	0	Absolute tolerance for numeric equality.
numeric_tolerance_pct	number (0..1)	0	Percent tolerance (e.g., 0.005 = 0.5%).
case_insensitive	bool	false	Apply case-insensitive comparison to both column names and data.
trim_whitespace	bool	false	Trim whitespace before comparing strings.
null_equals_empty	bool	false	Treat empty string as null when comparing.

Output 1 – Status & Scoring

Field	Description
student_id, assignment_id, problem_id	Echoed identifiers.
rows_submitted, columns_submitted	Counts of your submitted table.
matched_solution_version	Official solution variant that scored the highest.
score_percent, points_possible, points_awarded	Numeric results.
data_feedback	Summary sentence in normal/partial modes.
correct_column_names, correct_num_columns, correct_num_rows, wrong_sort_order, body_matches	Boolean flags to help interpret the score.
message	Exam mode returns “submission received”.

Output 2 – Feedback / Differences

• Normal: up to 10 mismatched cells with row, column, expected, actual.
• Partial: one-line message “Feedback limited (partial feedback)”.
• Exam mode: one-line message “Feedback hidden (exam mode)”.

Tip: Column-name and cell comparisons obey case_insensitive and trim_whitespace if enabled in the rubric.

Example Response – Normal

{

  "status": "ok",

  "student_id": "S123",

  "assignment_id": "A1",

  "problem_id": "P1",

  "rows_submitted": 3,

  "columns_submitted": 2,

  "matched_solution_version": 1,

  "score_percent": 80,

  "points_possible": 10,

  "points_awarded": 8,

  "data_feedback": "Data does not match the expected result.",

  "correct_column_names": true,

  "correct_num_columns": true,

  "correct_num_rows": false,

  "wrong_sort_order": false,

  "body_matches": false,

  "mismatches": [ {"row":1,"column":"total_sales","expected":1200.5,"actual":12000.5} ]

}

Example Response – Partial

{

  "status": "ok",

  "student_id": "S123",

  "assignment_id": "A1",

  "problem_id": "P1",

  "rows_submitted": 3,

  "columns_submitted": 2,

  "matched_solution_version": 1,

  "score_percent": 80,

  "points_possible": 10,

  "points_awarded": 8,

  "data_feedback": "Submission evaluated",

  "correct_column_names": true,

  "correct_num_columns": true,

  "correct_num_rows": false,

  "wrong_sort_order": false,

  "body_matches": false

}

Example Response – Exam

{

  "status": "ok",

  "student_id": "S123",

  "assignment_id": "A1",

  "problem_id": "P1",

  "rows_submitted": 3,

  "columns_submitted": 2,

  "message": "submission received"

}