Unable to Give Full Control to SharePoint Online Add-in

I registered an add-in on my SharePoint Online site collection by going to [Site Collection URL]/_layouts/15/AppRegNew.aspx
Noted Client ID and Client Secret. Trying to give it FullControl here: [Site Collection URL]/_layouts/15/AppInv.aspx by entering the following XML:

<AppPermissionRequests AllowAppOnlyPolicy="true">  
   <AppPermissionRequest Scope="Site Collection URL" 
    Right="FullControl" />
</AppPermissionRequests>

On ‘Do you trust the app page’ it does not ask me to give it Full Control but only the following:
Let it share its permissions with other users.
Let it access basic information about the users of this site.

What am I missing?

SharePoint hosted addin file not found

I am building SharePoint hosted add-in. I am trying to reference the sp.js and sp.runtime.js but I am getting error

File '_/layouts/15/sp.runtime.js' was not found. SharePointHostedAddin

Screenshot below:

Please help.

enter image description here

authentication – How to authenticate an Add-In on interprocess communication

We are considerung to build an Windows application that is split in 2 parts:
One part running as a Windows service and the other part as Add-Ins.
There could be different kinds of Add-Ins:
For Microsoft Office, for Microsoft Management Console (MMC) and for the PowerShell.

The service as well as the Add-Ins are digitally signed with a companies certificate and are all running on the same machine.
The service runs in a different user account than the Add-Ins.
The Add-Ins may run in various interactive user accounts.
The Add-Ins need to communicate with the Windows service to exchange a secret that is known to the service only, but is needed at the Add-Ins to get access to some sensitive data.
Therefor the Add-In would connect to the service (via e.g. named pipe) and requests that secret on demand.
But we need to avoid that another application/process does the same and gets the secret.
Only those Add-Ins that belong to our application (that are digitally signed with our certificate) may get the secret. In other words, the Add-Ins need some way to authenticate themself to the service.

So my question is:
How can the Add-Ins authenticate themself to the service while requesting the secret? Is it possible to use the digital signature (or someting else that is unique to them and to the service) for this?

It might get more difficult when considering, that the Add-Ins are hosted by processes that might be signed with different certificates (e.g. Word.exe, mmc.exe, …).

We are implementing on the .NET Framework.

Thanks for any kind of help.

reactjs – How to get colour palette of chart in excel add-in using office JS?

We are developing an excel add-in with react and office js APIs. We have added a chart and set the color to the chart from the color palette(chart-design -> Change Colours -> Colourful palette4).

Please refer the below screenshot ->

We wanted to get the color palette name or colors set to the chart. We checked through the office js documentation https://docs.microsoft.com/en-us/javascript/api/excel/excel.chart?view=excel-js-preview, We can get Style for the chart but we are not able to find anything related to getting a color palette.

Can anyone please help us to understand how to get a color palette using office js APIs?

sharepoint addin – System.UnauthorizedAccessException while trying through rest api.I am trying to get list of files in the folder

I have a sharepoint url access from front end and i am trying to access it through REST API in python

url = "mysharepoint_url/_api/web/GetFolderByServerRelativeUrl('" + folder + "')/Files"
header = {'Authorization': 'Bearer Token', 'accept': 'application/json;odata=nometadata'}
response = requests.get(url, header)

the response i get is

{"odata.error":{"code":"-2147024891, System.UnauthorizedAccessException","message":{"lang":"en-US","value":"Access denied. You do not have permission to perform this action or access this resource."}}}

I am using python here.. Please let me know if i am doing anything wrong. thanks in advance..
the same code works for different sharepoint url’s and folders.

Accept form POST request in Sharepoint Online Addin

I am trying to make a simple addin that accepts a POST request (from a File Handler) and makes the form data available for Javascript to use. It works fine when hosted locally, but when I tried to host it as a Sharepoint addin, I got an error Code blocks are not allowed in this file. When I remove the block that dumps the POSTed form to JS variables it loads without error, but the JS obviously can’t do its job.

Various sites say to add an entry to PageParserPaths in web.config, but that isn’t an option in Sharepoint Online.

How can I get POSTed form data in an addin? Do the Sharepoint JS libraries make it available some other way?

sharepoint addin – Create and debug a file handler

How do I create and debug file handlers? I tried following the Microsoft docs, but those docs and anything else I can find are out of date and I can’t tell if I’m missing a step or made an error in the config. I don’t see anything different in OneDrive/Sharepoint.

I also tried a sample file handler but that is also out of date and didn’t show in OneDrive/Sharepoint either.

Embed cefsharp in Outlook add-in

I would like to embed cefsharp in an Outlook plugin. Here I would like to open a Windows form via Ribbon running cefsharp. So far, I have not been able to make this work. Are there step-by-step instructions for a plugin? In a normal Windows Form application I already have it working.

How to identify which php file is using an add-in when loading the page?

I need to make some custom adjustments to a third-party add-in. My plan is to use PHPstorm and xdebug to immerse myself in the add-on as it loads / operates on a product page to find out how it works and make the appropriate changes. The only problem is that I don't know how to identify in which file to set breakpoints. Is there a correct way to do this? Is there any clue I can get when inspecting a page through the Chrome / Firefox development tools?

The specific add-on that I am trying to see is the prices and dynamic discounts of Rightpress and I want to debug it as it loads on the page of a product.

How to update existing add-in tables when the user updates the add-in

I am currently working on a new update for my add-on, the latest update contains changes and modifications to the structure of my add-in table.

I want to add some additional fields to my add-in tables, without these new additions, the add-in might not work properly.

I found multiple solutions to automatically update the structure of my table, however, I want this process to be as simple as possible.

Ideally, I would like to have this verification and update function activated only once when the user decides to update my add-on, instead of the function being executed each time the user decides to make a new query or reload the page, etc. But so far I have not found a suitable solution to do so.