Can we bind the api response to pivot table?

posted on October 22nd, 2020

Answered

Anil asked on October 22, 2020

Can we bind the response from the api to pivot table ? or does it require to be in the specified format? which mentioned in docs ?

Public

Vera Didenko ⋅ Flexmonster ⋅ October 22, 2020

Hello, Anil,

Thank you for reaching out to us.

Please see our answer below depending on your use case:

In case of a JSON or CSV API endpoint:
Sure, you can connect Flexmonster to your API to get JSON or CSV data.
The only requirement is for the resulting data (which will be passed to Flexmonster) to be in JSON (please see supported JSON formats) or CSV format.

The Flexmonster configuration will look like the following:
```
{
  dataSource: {
    type: "json", // or "csv"
    filename: "https://<path to your API endpoint>"
  }
}
```
Please see our data source tutorial for more details.
In case of custom data source API approach:

If you are using the custom data source API approach, then for each request the response should be in the specified format.

Please let us know if this helps. If further questions arise, feel free to reach out.
Looking forward to your reply.

Kind regards,
Vera