Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Parameter NameRequiredDescriptionValid ValuesDefault
sheetIdY

Google spreadsheet id



sheetNSheet name to pull data from a specific sheet in the spreadsheet
first sheet
envNThe environment to get Kuali Build user data from
  • prod
  • sbx
prod
filterColumnN

Column header name that will be used to lookup the Kuali User record using the GraphQL API.

The json will include the specified user's Kuali user ID, displayName, email, username, and schoolId.

  • UH_Username
  • Email
  • UH_Number

UH_Number

sortHeaderNColumn header name to sort the returned data on

(header)N

Supply a column's header as a parameter to filter rows based on the parameters value.

When using this the column's header cannot contain a space.

(ex: ColumnHeader=Value)