I have an external BAQ that is pointing at a view from an external DB. It runs fine in designer but when I execute the BAQ in REST with a filter on CustID or all . I get the following error.
"HttpStatus": 400, "ReasonPhrase": "REST API Exception", "ErrorMessage": "An incompatible primitive type 'Edm.Byte[Nullable=False]' was found for an item that was expected to be of type 'Edm.String[Nullable=True]'.", "ErrorType": "Microsoft.Data.OData.ODataException", "CorrelationId": "dc8c4b3b-f62c-4059-b317-a633c5d4c662"
I tried altering the view and adding ISNULL on the CustID column which did change the property in the SQL view from null to not null but I still getting the same results in REST. Any ideas on how to fix?