APIHub | API Hub for Pokemon GO | Video Game library

I have built a few custom connectors before but for some reason am having real issues getting a custom connector to authenticate against an api i have written.

The API is written in .netcore 5, hosted as a WebApp in the same tenant i am trying to connect from. I've checked the authentication setup and the ClientId is pointing to the 37008370 clientid guid in the below image.

This is how I am setting up the Auth in the connector

I've connected to this API using a blazor app so I think authentication is setup correctly.

When I try and setup the authentication for a custom connector though I get the following response

...

I have a microsoft forms that let user answer some questions and upload a picture. All the response will be saved into an excel table with power automate flow. Those answers will be save as string, URL point to OneDrive for the picture will be saved into excel table too.

Ok, many have ask the question on how to insert the picture into excel using that URL but so far no solution on that. The standard answer from Microsoft seems not working -- there is fetch error whenever the URL is point to OneDrive / SharePoint (Refer this link)

I'm asking the same question from another aspect. I can get the filecontent in power automate flow. When I download the file content and inspect it, it have the data structures like this (this is not full file content for security reason):

{"statusCode":200,"headers":{"Pragma":"no-cache","x-ms-request-id":"0f368276-7f62-4daa-82a7-98f5fda","Timing-Allow-Origin":"*","x-ms-apihub-cached-response":"false","Accept-Ranges":"bytes","Cache-Control":"no-cache","Date":"Mon, 11 Oct 2021 09:21:21 GMT","ETag":""{D2E67548-99EE-4BA3-BAB3},4"","Location":"https://flow-apim-msmanaged-na-centralus-01.azure-apim.net/apim/onedriveforbusiness/a47f3c2699aa4df70f3614572a9/datasets/default/files/01YEFL272IOXTNF.../content?inferContentType=true","X-AspNet-Version":"4.0.30319","X-Powered-By":"ASP.NET","Content-Length":"137453","Content-Disposition":"attachment; filename="16337833927412488499783584031011.jpg"","Content-Type":"image/jpeg","Expires":"-1"},"body":{"$content-type":"image/jpeg","$content":"/9j/4UVORXhpZgAATU0AKgAAAAgADQEAAAMAAAABCrAAAAEBAAMAAAABDkAAAAECAAMAAAADAAAA6gEPAAIAAAAHAAAAqgEQAAIAAAAIAAAAsgESAAMAAAABAAAAAAEaAAUAAAABAAAAugEbAAUAAAABAAAAwgEoAAMAAAABAAIAAAExAAIAAAAfAAAAygEyAAIAAAAUAAAA8AITAAMAAAABAAEAAIdpAAQAAAABAAABBAAABLxIVUFXRUkAAExZQS1MMjkAAAAASAAAAAEAAABIAAAAAUxZQS1MMjkgMTEuMC4wLjE2MChDNjM2RTdSMlA0KQAAAAgACAAIMjAyMToxMDowOSAyMDo0MzozNwAALgENAAcAAAAAAAAAAIKaAAUAAAABAAADUoKdAAUAAAABAAAETogiAAMAAAABAAIAAIgnAAMAAAABA+gAAJAAAAcAAAAEMDIxMJADAAIAAAAUAAAEXpAEAAIAAAAUAAAEcpEBAAcAAAAEAQIDAJECAAUAAAABAAAERpIBAAoAAAABAAADWpICAAUAAAABAAAEVpIDAAoAAAABAAADQpIEAAoAAAABAAADSpIFAAUAAAABAAAEPpIHAAMAAAABAAUAAJIIAAMAAAABAAEAAJIJAAMAAAABAAAAAJIKAAUAAAABAAADMpJ8AAcAAABkAAADcJJ8AAcAAAAEJAAAAJJ8AAcAAABqAAAD1JJ8AAcAAAAIAAADYpJ8AAcAAAAFAAADapKQAAIAAAAHAAAEhpKRAAIAAAAHAAAEjpKSAAIAAAAHAAAElqAAAAcAAAAEMDEwMKABAAMAAAABAAEAAKACAAQAAAABAAAKsKADAAQAAAABAAAOQKAFAAQAAAABAAAEnqIXAAMAAAABAAIAAKMAAAcAAAABAwAAAKMBAAcAAAABAQAAAKQBAAMAAAABAAEAAKQCAAMAAAABAAAAAKQDAAMAAAABAAAAAKQEAAUAAAABAAADOqQFAAMAAAABABsAAKQGAAMAAAABAAAAAKQHAAMAAAABAAAAAKQIAAMAAAABAAAAAKQJAAMAAAABAAAAAKQKAAMAAAABAAAAAKQMAAMAAAABAAAAAAAAAAAAABXMAAAD6AAAAGQAAABkAAAAAAAAAAEAAAAAAAAACgJiWgA7msoAAASP3QAAJxAjIyoqbm9yAEF1dG8AACMjIyMKAAAArsgzAQiAAQAAAAAAAAAAAAAAAAABAAAAVAQAAP////////////////////////////////////////////////////////////////////////////////////...==}}

From what I can tell, strings after "body":{"$content-type":"image/jpeg","$content":, starting from /9j/4UVORX until ...== is the base64 string for that image which logically could be pass to an OfficeScript and call worksheet.AddImage API to insert full picture into excel worksheet as image directly.

Anyone have any idea on how to extract the base64 string using OfficeScript if I pass the filecontent from power automate flow to OfficeScript?

===Add-on===

After some reseach, I manage to extract the correct string out of file content using json function:

...

I'm trying to create an MS Powerapp Custom Connector to access an ASP.NET core WebAPI, which is protected by Azure AD using the Microsoft.Identity.Web package. But no matter how I try to set things up, I'm always getting a 401 when trying to access the API via the connector.

So my setup looks like this:

Azure App registrations

I have registered two apps in Azure App Registrations. One for the API and one for the Powerapp Connector.

For the API registration I only configured settings under 'Expose an API'. I set an Application ID URI

api://f9****ca-****-****-****-3d30e9e*****

and added a scope

api://f9****ca-****-****-****-3d30e9e*****/Employees.Read.All

I also added an authorized client application using the ID of the App registration for the Powerapp (config below).

The app registration for the Powerapp is configured as follows:

For authentication the Web platform is added with redirect URI of https://global.consent.azure-apim.net/redirect.

Under 'Certificates & secrets' I added a client secret.

Under 'Api permissions' I added a permission for the scope of the API api://f9****ca-****-****-****-3d30e9e*****/Employees.Read.All as Delegated permission.

Powerapp Custom Connector config

The security tab of my custom connector is configured as follows:

Setting Value Auth type OAuth 2.0 Identity Provider Azure Active Directory Client id Client Secret Login URL https://login.windows.net Tenant ID Resource URL api://f9****ca-****-****-****-3d30e9e***** Scope api://f9****ca-****-****-****-3d30e9e*****/Employees.Read.All ASP.net core (3.1) Web App

I'm using the Microsoft.Identity.Web nuget package.

In my app config I added the following:

...

I have created a small Logic App that queries CDS. The response is chunked and I need the value of the property "x-ms-request-id" from "headers".

...

I am having Azure SQL database and I want to perform Insert,Update,Delete Operations by using Logic Apps and is it necessary to have a gateway while Connecting to Azure SQL DB to Sqlserver Connector in Logic -app I have Three properties 1)Id 2)Name 3)Department in Azure SqlDB

...

I am trying to use to sen2r() function (Package sen2r_1.3.2) with default parameters but getting the following error:

Error in paste(c(...), collapse = sep) : argument is missing, with no default.

I know the error wants me to fill in some parameters, but the source manual clearly says that the default should work, and the parameters can be set subsequently upon launching the GUI.

Using the s2_gui() launches the shiny app, but keeps hanging when I try to "Save and Close"

...

My work flow is like this.

INPUT log ...