Pivot Table Custom Error Handling

Hello, Will!

Thank you for writing to us.

Yes, you can customize error handling in Flexmonster to manage different fault scenarios with different data sources. There are three key aspects to consider for implementing custom error handling:

Using events to track errors
You can listen to specific Flexmonster events to detect when an error occurs and take appropriate action. These include the olapstructureerror and the queryerror events for fetching the data with custom API and dataerror event for loading remote CSV/JSON. You can find the list of all available events on this page: https://www.flexmonster.com/api/events/

Showing own alerts
You can display the alert pop-up with a custom error message using the alert API call.

Overriding default error messages
The existing error messages can be customized via localization, in the localization.messages object. We want to mention that localization can be specified fully via file or partially by overriding specific labels (see example).

Please let us know if you need further guidance on the implementation.

Best Regards,
Maksym

Hello, Will!

Hope you are doing well.
We would like to know whether you have tried the suggested approaches to customize error handling.
Looking forward to hearing your feedback.

Best Regards,
Maksym

Hello, Will!

Thank you for your feedback.
We are glad to hear that one of our proposed solutions worked for your case.
Please let us know if any other questions arise.

Best Regards,
Maksym

Hello, Will!

Thank you for reaching out to us.

Flexmonster does not provide a direct way of disabling default error pop-ups because they provide essential information for troubleshooting. However, you can automatically close error pop-ups appearing in Flexmonster using the MutationObserver, as is shown in this example: https://jsfiddle.net/flexmonster/20etvg17/

Please let us know if this approach would work for you.

Best Regards,
Maksym

Hello, Will!

Thank you for reaching out to us.

For such an advanced approach to error handling, we recommend using a functional API for greater control over individual request processing. This approach allows you to define a function as an API endpoint in the dataSource.url parameter:

    dataSource: {
      type: "api",
      url: pivotEndpoint,
      index: "fm-product-sales",
    }

For your use case, this function should act as a proxy between Flexmonster and your server, forwarding requests while implementing response error handling. This ensures that network failures, invalid responses, or other issues can be properly managed before data reaches the pivot table.

You can reference this JSFiddle, which demonstrates the implementation of a functional endpoint forwarding requests to the server: https://jsfiddle.net/flexmonster/h3k2qwe1/. Kindly note that error-handling logic should be implemented on your end.

Please let us know if any questions arise.

Best Regards,
Maksym

Hello, Will!

Thank you for your reply.

You can find a more in-depth explanation of the function-based approach for custom API connection in this support forum thread: More user friendly way to tell the user there is no data when using Custom Data Source API

Also, remember that this approach can cause issues when saving the report as a JSON file. The saved report JSON does not include the function from the url parameter. This means the report cannot be restored without manually reattaching the function after loading the saved configuration.

If saving and reloading reports is crucial for your project and you want to avoid such workarounds, you might want to consider a different approach to handling server errors.

We are looking forward to hearing your feedback.

Best Regards,
Maskym

Hello, Will!

Hope you are doing well.
We are wondering if you implemented the server response error handling using a function for custom API connection.
Please let us know if you need any further assistance.

Best Regards,
Maksym