I can get the members request to work but I don’t know how to format the select request for the pivot table
could you please give me the /select response format
Thank you for reaching out to us.
Our team would like to explain that the built-in
year/quarter/month/day date data type is not implemented for the custom data source API.
However, it is possible to create such a date data structure by combining separate fields into a multilevel hierarchy.
For example, it is possible to create separate fields representing each level:
"day". Then these fields can be united to create a multilevel hierarchy that will represent the
year/quarter/month/day date. The multilevel hierarchy can be configured via the mapping property.
Also, for multilevel hierarchies to work for the custom data source API, advanced filters need to be implemented on your server.
Please see the following Support Forum thread for more details: https://www.flexmonster.com/question/is-it-possible-to-describe-hierarchies-with-the-custom-data-source-api/
For a better understanding of the required response structure for the
/select request, please see the requests and responses when a hierarchy level is selected in the following JSFiddle example: https://jsfiddle.net/flexmonster/o4jywt38/ (by inspecting the page and navigating to the network tab).
Please let us know if this helps. If any further questions arise, please feel free to reach out.
thank you this should solve my issue