Webhook URL update for Power Automate

[AndrewThompson_SCE]

Hi All, 

I am trying to update my webhook settings for my Power Automate flow. I got a notification that the URL in Power Automate has changed and need to update. 

When I go to update it in the Notifications > Webhook Settings, I get this error. 

update "notifications" set "webhook_url" = $1 where "id" = $2 - value too long for type character varying(255)

Any ideas on what I need to do? 

Thanks!

[CarlVon_Stetten1]

How long is the new URL (number of characters)?  Could it be longer than 255 characters?

[AndrewThompson_SCE]

Yes, it is actually. How would I be able to shorten it? Would that maybe fix it? 

[CarlVon_Stetten1]

I'm not really familiar with Power Automate, so I don't know if this is possible...  Can you work with whoever manages your Microsoft services to see if they can somehow simplify the URL or set up an alias for the domain/subdomain to be shorter?  Alternatively, you might be able to set up some kind of reverse proxy that uses a shorter URL and redirects over to the longer Power Automate URL.

[AndreasHall · Accepted solution]

I have the same issue with a webhook in ArcGIS Enterprise (Portal). As I understand it, it is not possible to get a shorter URL out of Power Automate. However, it might work to use an URL shortener, e.g. Bitly. I have not had time to test this yet but it is on my to-do list. 

[AndrewThompson_SCE]

I didnt think something like that would work, but I used TinyURL and it seems to be working now. 

[KevinHibma]

For organization webhooks (ie webhooks created in Portal), we have an issue logged and will attempt to fix it in the 12.1 release of Enterprise. The problem, as identified, the URL length has become longer than the database field allows for the URL value. It seems like Monitor has the same problem.

BUG-000179555 - When attempting to register an organization webhook in ArcGIS Enterprise using a Power Automate Request connector's "When an HTTP request is received" trigger URL, the operation fails with a database error.

[AndreasHall]

I did test and it did not work for me.

[StefanUseldinger]

I was also unable to use the URL shortener tinyurl on our two Enterprise 11.5 instances, even though the firewall allows the requests to pass through correctly (http 200).

{
	"error": {
		"code": 400,
		"messageCode": "WEBHOOKS_014",
		"message": "Unable to update webhook for the account '0123456789ABCDEF' due to 'Cannot reach Webhook URL 'https://tinyurl.com/xyz' due to '\nException: status code: 403, reason phrase: Forbidden'.'",
		"details": [
			"Unable to create or update webhook. Non reachable URL : 'https://tinyurl.com/xyz' has been specified for the webhook with name or id 'Portal Webhook'"
		]
	}
}