Is it possible to automatically update a URL (Link destination)in the interface designer?

Question

Hi

I have a set of workflows which are run a few hundred times each month. Before each month I have to edit the interface section for the URL as it changes to reflect the previous month.

Is it possible to push some automated code in to this which looks up which month is it, and amends the URL accordingly in the interface designer - I'm thinking that most of the URL is text so i can just create it with an '+' but i don't see any way of pushing this into the interface as it's hard coded.

Thanks

Carlithian · Answer

Ah, I took it as interface tools, not interface designer that was being updated. If it still something you can edit, but not as clean in workflow.

Personally I would create a workflow to update the XML of the interface designer properties and have that run on schedule at the beginning of the month.

That would look something like this, a workflow that brings in the alteryx file, a formula to identify the xml line that the link exists on, the info in the linkdest tags will be start off as what you have hardcoded, but it would need to be dynamic going forward, like in the second image.

Hope this helps, was an interesting problem to figure out :)

Example Link Override.yxwz

Example XML Override.yxwz

BecclesBen · Answer

SS attached - thank you!

The URL is:

ttps://apps.cloudhealthtech.com/reports/usage/instance-hours?period_val=2022-09-01&aws_account_id=&aws_availability_zone_id=&is_active=All&type=All&aws_instance_type=All&status=All&tenancy=All&has_tags=All&tag_key=All&tag_value=&start_before_time=&start_time=&stop_time=&stop_after_time=&launched_in=&display_names=account.name,instance.name,instance_type.api_name,availability_zone.name,instance.is_spot,total_hours,total_cost,on_demand_hours,reserved_hours,spot_hours,ec2_savings_plan_hours,compute_savings_plan_hours,used_pct,savings_plan_pct,full_cost,reservation_pct,compute_cost,instance_type.type,aws_instance_type.product,month&sort_order=-total_cost

And the part with the date in is: "period_val=2022-09-01" which will change by 1 month of course!

Screenshot 2022-10-26 102442.jpg

Carlithian · Answer

can you send a screenshot of the interface you are working with, I can try put together an example for you :)