Skuid parses OData response incorrectly when attempting to aggregate data.
- API Version: v2
- Release: Chicago
- Release version: 14.4.16
- Platform: Salesforce
Created a model where Odata should aggregate the model via multiple Joins, e.g.
In SOQL it would be:
SELECT SUM(NumField), LookUpField.Obj2LookUpField.Obj3LookUpField.Obj4LookUpField groupField FROM Obj1 GROUP BY LookUpField.Obj2LookUpField.Obj3LookUpField.Obj4LookUpField.Name
The OData URL would be (this is produced by Skuid:
https://<OdataWebService>/v1/Obj1Endpoint?$apply=groupby((LookUpField/Obj2LookUpField/Obj3LookUpField/Obj4LookUpField/Name), aggregate(NumField with sum as NumField))
The model groups fields by groupField and returns respective sum.
The model returns the respective sum, but the groupField is null. Though, if I copy/pate the url I get the result I would expect.
It would be nice if Skuid would provide a payload snippet where we can parse this information how we want to. Similar to Apex Rest