RedJade recently updated the Excel raw data file format, providing additional options for download (labeled and numeric-labeled) as well as making the Excel file easier to read and locate data. The header row has been split to allow the file to be easier to work with, especially when needing only reporting names as the header row label to import data in to third-party software systems.
The old legacy data file format remains available to support existing users that have custom templates built, typically used to extract and transform data for various custom workflows. However, the legacy file format has been deprecated and will not receive any further system updates.
On July 1, 2023 the old legacy raw data file format will be retired and no longer available to end-users. Additional reminders will be posted in-app at 6 months, 3 months, 1 month and 1 week leading up to the retirement date.
Who is impacted by this?
Users that have custom workflows (templates, scripts, macros, formulas, etc.) that extract and transform Excel raw data downloaded from the RedJade Analyses and Recruiting Campaign web pages, or through the RedJade API.
What do you need to do to prepare?
Update your custom workflows (templates, scripts, macros, formulas, etc.) to work with RedJade's new Excel raw data file format by June 30, 2023 – see Download Raw Data and Download Screener Raw Data for further details.
RedJade API Users:
If downloading Excel raw data through the RedJade API, the old legacy file format is currently the default. You can add '?data_labels=numeric', '?data_labels=labeled', or '?data_labels=numeric-labeled' to request the new format, for example:
sensory_test_id=123
curl -X POST "https://app.redjade.net/api/v1/sensory_tests/$sensory_test_id/export_raw_data/?data_labels=numeric" -H "authorization: Bearer $bearer_token"
curl -X POST "https://app.redjade.net/api/v1/sensory_tests/$sensory_test_id/export_raw_data/?data_labels=labeled" -H "authorization: Bearer $bearer_token"
curl -X POST "https://app.redjade.net/api/v1/sensory_tests/$sensory_test_id/export_raw_data/?data_labels=numeric-labeled" -H "authorization: Bearer $bearer_token"
curl -X POST "https://app.redjade.net/api/v1/sensory_tests/$sensory_test_id/export_raw_data/?data_labels=legacy" -H "authorization: Bearer $bearer_token"
When the legacy file format is retired on July 1, 2023, the default call for 'export_raw_data' will provide the new Excel Numeric format. The other format specific calls will continue to work.