SYMPTOM:
When importing a data using URL Data Import feature in Strategy Web 10.7, users receive the error "Error 400 - Cannot perform query. Invalid query parameters. ('where' parameter is invalid) when using JSON URL"
STEPS TO REPRODUCE:
1. From Strategy Web, select Add External Data > Data from URL.
2. Use the following URL:
https://services5.arcgis.com/qQFqGVQn6Lw43AeO/ArcGIS/rest/services/vIOux/FeatureServer/0/query?where=1%3D1
3. Select Anonymous Authentication and click Prepare Data
4. In the data preparation screen, it shows Error Code: 400 . Error message: Cannot perform query. Invalid query parameters. Error details Enum: 'where' parameter is invalid.
CAUSE:
This is an identified defect in Strategy Web version 10.7, where the "%" sign after the "where" clause was translated to %25.
ACTION:
This issue has been addressed in Strategy Web version 10.8 and 10.4 Hotfix 4.
The Strategy internal reference number for this issue is DE59957.
