Formula.Firewall error

hello Anonymous 

okay, than these request has nothing to do with an Firewall-error. 

Change your query into a function and invoke it in a new custom column and passing the product id

Function name. 

//GetProductImage
(productid) =
let
        Source = 
            Json.Document(
                Web.Contents("https://hostname.app.de/rest/unprotected/files/images/products/getImageURLBySKU?sku=[" & productid & "])
            ),
            
    imageURL = Source[result]
    in
        imageURL

and in your table invoke it in a new column like this

GetProductImage( [Product ID])

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

Hello Anonymous 

I've just checked your error message again, and it seems that the error is caused due to different settings of your data sources. So please try to go go Datasourcesettings (Datenquelleneinstellungen) and set the same settings for every data source (public i suppose). This should solve your problem.

All the best

Jimmy