I recently dealt with a requirement whereby I needed to export only certain columns from records on a given table that match a given query, to a CSV file.

“No problem”, I said; “that’s easy. You just add ‘?CSV’ to the end of the table URL.”

Oh, but it’s never that easy, is it? In this case, there were a few odd stipulations:

• The header names need to be specific strings (not the same as their column names in ServiceNow)

• Some of the columns need to have calculated or static values; values not in ServiceNow (and we don’t want to make calculated columns for them)

• The endpoint must not return CSV data embedded in a JSON response body, but must actually return a CSV file. Or to put it more precisely, the endpoint URL must resolve to a CSV file.

Because of the nature of this requirement, I was going to need to create a Scripted REST API (SRAPI); so I did…

Click below to read more!