Hi - looking for someone with SharePoint online integration experience to help me integrate our help desk (/CRM/Invoicing system) with SharePoint Online (we have plan 2 SPO). I would like to be able to have external data site columns to use across our site collection - I have no experience with REST API’s or external data in SPO, but have done other types of integrations & novice database design before so can work with you to determine options/best way to do if any of what I am after is not possible.
I can create a user account for our Office 365 environment if you need to look at that before starting, I also have a development tenant setup.
I need to be able to create custom columns to go alongside this information/extend it, that’s the goal.
REST API specs as per RepairShopr KB article:
"Our API has a very simple authorization, a user-level API key passed as a param
This is subject to change but currently we'll allow 120 requests per minute for each account before responding with an error.
We return all data as json. When sending data in to us you can use regular form encoding or set the content type to json and use it in the body.
You can send a simple HTTP GET to many endpoints, just pass the api_key parameter like so;
GET [login to view URL]
Please note that all requests must be HTTPS as opposed to HTTP.
All the endpoints are paginating. You can add a param like &page=2 to the request to get to the other pages. Here are the defaults;
NB: INITIAL BUDGET MAINLY TO WORK OUT WHAT IS POSSIBLE, BUILDING CMDB SO IF YOU ARE FAMILIAR WITH THESE SYSTEMS, THERE WILL BE OTHER WORK AND BUDGET WILL INCREASE DEPENDING ON WHAT WE CAN DO WITH THE API