We have updated Flexmonster Software License Agreement, effective as of September 30, 2024. Learn more about what’s changed.
Get Free Trial
Get Free Trial

I want add filter search in flexmonster using Web APi2 in exiting project

posted on October 12th, 2020

Answered
Faizan Hamz asked on October 12, 2020

I want add filter search in flexmonster using Web APi2 in exiting project or pass paraments.
here i pass API path.
pic 1
https://prnt.sc/uxiuhd
or write "customizeAPIRequest"
pic 2
https://prnt.sc/uxiv9a
This is my MVC Web AP's
pic 3
https://prnt.sc/uxixfm
basically i want different paraments in API's pi or API's retune data or i have to pass it to Flexmonter Report Grid.
Thanks

7 answers

Public
Illia Yatsyshyn Illia Yatsyshyn ⋅ Flexmonster ⋅ October 12, 2020

Hello,
 
Thank you for reaching out to us.
 
If we understand correctly, your requirement is to filter the data based on some parameters passed from the client-side. In your case, these parameters may be included in the URL or passed as request headers.
Please let us know in case your requirement differs from the described above.
 
If our assumption is correct, we want to ask you for some additional details about your particular use case:

  • Do you use our Flexmonster Data Server as a data source? If so, we suggest checking our guide dedicated to server-side filtering. It describes the approach to filter the data based on request headers received from the client.
  • Do you use your implementation of the custom data source API instead of Flexmonster Data Server? It implies developing custom server-side application that would handle processing and providing the data.
  • In your case, are queries to your data storage predefined, or they need to be composed dynamically using received parameters?

 
This information would allow us to find the most suitable solution for your case.
 
Our team is looking forward to hearing from you.
 
Kind regards,
Illia

Public
Faizan Hamz ⋅ October 13, 2020

Thanks For your Replay 
step 1
Basically i want to fetch data from API and fill data in grid .[flexmonster pivot ]. 
i am using Asp.net mvc web Api 2.0,
step 2
fetch data from API With Parameters
i just pass Parameters in my custom API's and that data which API's retune want to fill data in grid .[flexmonster pivot ].
That's it

Thanks

Public
Illia Yatsyshyn Illia Yatsyshyn ⋅ Flexmonster ⋅ October 15, 2020

Hello,
 
Thank you for giving us some time.
 
Our team wants to ask you for some additional details to get a better understanding of your use case:

  1. Where are your data sets stored? Do you use inline JSON (preloaded to the page), database, or remote JSON/CSV files?
  2. Do you need to process the data (mine it from your storage, aggregate, etc.) on the server? If so, what is the purpose of the parameters passed from the client-side?

 
Please provide us with the mentioned details so that we could provide you with suggestions.
 
Our team is looking forward to hearing from you.
 
Kind regards,
Illia

Public
Faizan Hamz ⋅ October 16, 2020
  1. Where are your data sets stored? Do you use inline JSON (preloaded to the page), database, or remote JSON/CSV files?
    its come from database [SQL server ]. or also JSOn file .
    i need both.
  2. Do you need to process the data (mine it from your storage, aggregate, etc.) on the server? If so, what is the purpose of the parameters passed from the client-side?
    No processing 
    just come data as "Select * from tbl_All_Sale"
    i just pass data to grid which come from API's
    i need to pass dataSource type as "API".
    Thats it
     

 

Public
Faizan Hamz ⋅ October 16, 2020

Or please Tell me best data 


flexmonster best data source
 

Public
Faizan Hamz ⋅ October 16, 2020

HI gave me demo for large amount of data my data is 1GB JSON file.
the problem is on Clint side 1Gb take much time to dogwood or show data in Pivot.
Please gave me a demo where i test this large amount of data and then i buys license if its fulfilled my requirement.
curranty am suing Asp.net Mvc 5 , or database MS-SQL server.
Hope you understand or gave me best solution
Note : i already check all demo or many articles all things Good , but not happy at all with large amount of data.
Waiting yours kind Respond .

Public
Illia Yatsyshyn Illia Yatsyshyn ⋅ Flexmonster ⋅ October 19, 2020

Hello, Faizan,
 
Thank you for providing us with details.
 
The recommended way to establish a connection with large JSON files and databases (including Microsoft SQL Server database) is to use Flexmonster Data Server.
Flexmonster Data Server is a special server-side tool responsible for fetching data from a data source, processing, and aggregating it.
Flexmonster Data Server can process files more than 1GB — the maximum file size depends on your RAM capacity and the number of unique members in the dataset.
If the Data Server is used, the load on the client-side is significantly reduced. It is because all calculations are delegated to the server-side. In its turn, the client receives the already aggregated data in a ready-to-show format.
 
We recommend checking out the following guides to learn more about how to connect to your data sources with Flexmonster Data Server:

 
General information about the Data Server can be found in our documentation.
 
We hope it works for you.
Please contact us if you have any questions on this point.
 
Kind regards,
Illia

Please login or Register to Submit Answer