OVERVIEW
Okta Workflows File Download Card results in error "Unknown Error: Internal Error: OctopusError { desc: "HTTP Error", details: "{\"error\":{\"status\":500,\"message\":\"insert into \\\"org_files\\\" (\\\"created\\\", \\\"name\\\", \\\"org_id\\\", \\\"size\\\", \\\"type\\\", \\\"updated\\\", \\\"user_id\\\", \\\"uuid\\\") values ($1, $2, $3, $4, $5, $6, $7, $8) returning \\\"id\\\" - value too long for type character varying(255)\"}}", kind: Http }, ErrorMetadata { method: Some("XaVM78OgXX6L"), flo: Some(String("filefunctions:1.0.37:largeDownload"))
APPLIES TO
-
Okta Workflows File Download card
-
URLs containing more than 255 characters after the trailing slash
CAUSE
The Okta Workflows File download card will use the characters after the trailing slash in the URL to name the resulting downloaded file. If there are more than 255 characters after the trailing slash, this error will be returned.
SOLUTION
If the URL contains a query parameter (? after the trailing slash) the query parameter can be separated from the URL, and thus be separated from the file name. As long as there are less than 255 characters between the trailing / and the ? this approach will prevent the file download error.
This example shows the query parameter as "access_token". If the query parameter is some other value, the Text - Split card must reflect that value, and the Key defined for the Query in the File - Download card must also reflect that value.
