Export to CSV API-1006 error when filter contains # or &
search cancel

Export to CSV API-1006 error when filter contains # or &

book

Article ID: 282573

calendar_today

Updated On: 04-30-2024

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Clarity job is not Exporting to CSV after filtering in MUX Project or Custom Object when any filter parameter code contains # or & symbol. For reproduce issue we need a custom string attribute on Project or Custom Object or just use the OOB string attribute like Description or Originating Template and use code containing # or & symbol when filtering at Project.

Steps to Reproduce:

  1. Login as Admin user to MUX
  2. Navigate to Projects or Custom Objects workspace
  3. Click on any Project/CIT [create if not exist]
  4. Add Filter having special characters like (“&”, “#” etc..)
  5. Run the Export to CSV feature from Actions

Expected Result: Special characters like (“&”, “#” etc..) should be allowed to Export to CSV without any error.

Actual Result: Clarity is throwing an error in the Job Type: Export to CSV Job - Job Properties

Export Job Failed: 400
api.invalidAttrValue
API-1006 : The value ''%' for Attribute 'description' is not in expected format or is invalid.

Export Job Failed: 400
api.invalidAttrValue
API-1006 : The value ''%' for Attribute 'z_inv_case1' is not in expected format or is invalid.

Environment

Clarity 16.2.1.

Cause

DE80536

Resolution

This issue is a duplicate of DE78935.