How long does it take for an app to be registered? I created a new app but get the following error:
Unknown Application
We don’t recognise this app. Please get in touch with the author of the application you’re trying to approve.
Thanks, Bruce
How long does it take for an app to be registered? I created a new app but get the following error:
Unknown Application
We don’t recognise this app. Please get in touch with the author of the application you’re trying to approve.
Thanks, Bruce
Hi Bruce
Jamie from FreeAgent here.
I would expect the app to be registered once it has been authenticated, which needs to be done after the app has been created via your dev dashboard account. I’ve had a look and I cannot see that you have setup an app, so I am wondering if you have yet to authenticate the app, which can be done following the guidance here.
I hope this helps, do let me know if you have any other questions!
Thanks,
Jamie
Thank Jamie,
I think I have managed to register the app now and moved a little further forward with help from this thread but now I am stuck. What am I doing wrong?
My Power BI code is as follows:
let
Query2 = let
app_credentials =“client_id=[HIDDEN]&client_secret=[HIDDEN]”,
url = app_credentials & “&refresh_token=” & “[HIDDEN]” & “&grant_type=refresh_token”,
GetJson = Web.Contents(“https://api.freeagent.com/v2/token_endpoint”,[Headers = [#“Content-Type”=“application/x-www-form-urlencoded”],
Content = Text.ToBinary(url)]),AccessToken = Json.Document(GetJson)[access_token],
AccessTokenHeader = “Bearer " & AccessToken,
Source = Xml.Tables(Web.Contents(“https://api.freeagent.com/v2/”, [RelativePath=“accounting/profit_and_loss/summary?from_date=2024-10-01&to_date=”&Text.From(Date.Year(DateTime.LocalNow()))&”-“&Text.From(Date.Month(DateTime.LocalNow()))&”-01", Headers=[#“Authorization”=AccessTokenHeader, Accept=“application/xml”, #“Content-Type”=“application/xml”]])),
Table0 = Source{0}[Table]
in Source,
Table = Query2{0}[Table],
#“Expanded from” = Table.ExpandTableColumn(Table, “from”, {“Element:Text”}, {“from.Element:Text”}),
#“Expanded to” = Table.ExpandTableColumn(#“Expanded from”, “to”, {“Element:Text”}, {“to.Element:Text”}),
#“Expanded less” = Table.ExpandTableColumn(#“Expanded to”, “less”, {“less”}, {“less.less”}),
#“Expanded less.less” = Table.ExpandTableColumn(#“Expanded less”, “less.less”, {“total”}, {“less.less.total”}),
#“Renamed Columns” = Table.RenameColumns(#“Expanded less.less”,{{“less.less.total”, “Corporation Tax”}}),
#“Removed Bottom Rows” = Table.RemoveLastN(#“Renamed Columns”,2),
#“Changed Type” = Table.TransformColumnTypes(#“Removed Bottom Rows”,{{“income”, Int64.Type}, {“expenses”, Int64.Type}, {“operating-profit”, Int64.Type}, {“Corporation Tax”, Int64.Type}, {“retained-profit”, Int64.Type}, {“retained-profit-brought-forward”, Int64.Type}, {“retained-profit-carried-forward”, Int64.Type}}),
#“Merged Queries” = Table.NestedJoin(#“Changed Type”, {“from.Element:Text”}, Y6, {“from.Element:Text”}, “FAProfit22/23”, JoinKind.LeftOuter),
#“Removed Columns” = Table.RemoveColumns(#“Merged Queries”,{“FAProfit22/23”, “retained-profit”, “retained-profit-brought-forward”, “retained-profit-carried-forward”}),
#“Added Custom” = Table.AddColumn(#“Removed Columns”, “NetProfit”, each [income]-[expenses]-[Corporation Tax])
in
#“Added Custom”
Many thanks
Hi Jamie, Did you see my earlier reply? I’m still stuck and would love it if you could help.
Many thanks, Bruce