Can I find a SharePoint excel data provider ?

Data provider

10 Replies

kapa.ai•15mo ago

Hi @berdailabs. I'm kapa.ai, your friendly support bot. I will try to answer your question by searching through the knowledge base. :wave: ---------------------- A data provider in refine acts as a data layer for your app, making HTTP requests and encapsulating how the data is retrieved. Refine consumes these methods via data hooks. Data providers can communicate with REST, GraphQL, RPC, and SOAP-based APIs, serving as an adapter between refine and the API. A typical data provider includes the following methods to perform data operations:

const dataProvider = {  
 create: ({ resource, variables, meta }) => Promise,  
 createMany: ({ resource, variables, meta }) => Promise,  
 deleteOne: ({ resource, id, meta }) => Promise,  
 deleteMany: ({ resource, ids, meta }) => Promise,  
 getList: ({ resource, pagination, sorters, filters, meta }) => Promise,  
 getMany: ({ resource, ids, meta }) => Promise,  
 getOne: ({ resource, id, meta }) => Promise,  
 update: ({ resource, id, variables, meta }) => Promise,  
 updateMany: ({ resource, ids, variables, meta }) => Promise,  
 custom: ({ url, method, sorters, filters, payload, query, headers, meta }) => Promise,  
 getApiUrl: () => "",  
};

const dataProvider = {  
 create: ({ resource, variables, meta }) => Promise,  
 createMany: ({ resource, variables, meta }) => Promise,  
 deleteOne: ({ resource, id, meta }) => Promise,  
 deleteMany: ({ resource, ids, meta }) => Promise,  
 getList: ({ resource, pagination, sorters, filters, meta }) => Promise,  
 getMany: ({ resource, ids, meta }) => Promise,  
 getOne: ({ resource, id, meta }) => Promise,  
 update: ({ resource, id, variables, meta }) => Promise,  
 updateMany: ({ resource, ids, variables, meta }) => Promise,  
 custom: ({ url, method, sorters, filters, payload, query, headers, meta }) => Promise,  
 getApiUrl: () => "",  
};

Refine offers built-in data provider support for popular API providers, so you don't need to create data providers from scratch. You can also create your own data provider if needed. To activate the data provider in refine, pass the dataProvider to the <Refine /> component:

import { Refine } from "@refinedev/core";  
import dataProvider from "./dataProvider";  

const App: React.FC = () => {  
 return <Refine dataProvider={dataProvider} />;  
};

import { Refine } from "@refinedev/core";  
import dataProvider from "./dataProvider";  

const App: React.FC = () => {  
 return <Refine dataProvider={dataProvider} />;  
};

For more information, refer to the Data Provider documentation (https://refine.dev/docs/api-reference/core/providers/data-provider/). ---------------------- Note: you can ask me a follow up question by @ mentioning me again :speech_balloon: ----------------------

kapa.ai•15mo ago

<@911563296493142046> kapa.ai is still learning and improving, please let us how it did by reacting below

xenophobic-harlequin•15mo ago

Hey @berdailabs, You can create your own data provider to connect ant third party entegration.

conscious-sapphire•15mo ago

@salihozdemir thanks but it's not easy because in SharePoint I will use openid connect and msal conf Auth of Microsoft and after I will use API graph to get data from SharePoint and mapping it in data provider ... I'm sure I will buy it if can someone do it because it take a lot of time My company need a proof of concept in two week if so they use react-admin and there providers But I prefer refine 😄 two big European bank companies they test refine and react admin ... Actually in architect department

xenophobic-harlequin•15mo ago

Thanks 😅 However we haven’t have a plan to create a new data provider yet. If you create an issue, we may include it our roadmap.

conscious-sapphire•15mo ago

It's so powerful to create a data provider I know it's so hard to maintain it but look a the advantages , for example I just make a demo using a strapi and refine last week and my client is a big french bank Today I have two clients that they need SharePoint demo using Excel but I can't show it because of time taking but still of your workk

xenophobic-harlequin•15mo ago

You are right, but we don't have time to do everything. At this point we need the support of the community. 🙏

adverse-sapphire•15mo ago

Hello @berdailabs we are happy that these companies are considering us. We’d like to help you through the process. We dont have much different dataproviders, it should be easily possible to reuse react admin’s data provider.
You can start with installing fake rest data provider and then swizzle it with refine cli. This should give you some boilerplate to start with. Then you can modify the data provider similarly as in the other provider. Give it a shot and let us know if you stuck somewhere. We’d be more than happy to help!

conscious-sapphire•15mo ago

@batuhanw thank you so much for your feedback I will do it step by step .. This is a good tips hack @batuhanw Hello ,are fine ? so react-admin they just release a msal data provider using mcirosoft sharepoint api graph ,i think that i will use there package with refine and test it .. 🙂

adverse-sapphire•15mo ago

Hey @berdailabs , great to hear! Let us know if you need any help!