When exporting a PDF of a Dashboard using the API, it accepts ZOHO_CRITERIA which comes from a single table, but won't export when the criteria contains more than one table.
For example, imagine a simple dashboard with two charts, one showing sales by region and one showing the number of registered customers by gender.
Works: ZOHO_CRITERIA=("Sales"."Region"='West')
Works: ZOHO_CRITERIA=("Customer"."Gender"='Male')
Works: ZOHO_CRITERIA=("Sales"."Region"='West' OR "Sales"."Region"='East')
Doesn't work: ZOHO_CRITERIA=("Sales"."Region"='West' OR "Customer"."Gender"='Male')
I was hoping the v2 API would fix this problem but it doesn't. It does provide some clarification to the problem, which is better than before (empty 400 response), but I can't figure out how to fix it.
v2 API Response 400: {"status":"failure","summary":"FILTER_CRITERIA_NOT_MATCHED","data":{"errorCode":7328,"errorMessage":"The specified filter criteria cannot be applied to any of the inner view of the dashboard"}}