Glad to help - easy answer here is, yes, tags can be created and updated within a workflow. Using the Device Update node would allow you to perform this operation. We’ve seen questions around this before and I would recommend taking a look at the following forum threads:
Maybe I’m unclear on your use case, but creating, updating and managing device tags seems unnecessary if you are already adding the SQL value post-lookup on the payload? Also, tagging is useful for assisting with the organization of your devices but would not be the ideal method for reporting or storing state information.
At this point, you’ve already accessed your database, performed the proper lookup and added the associated value to the payload - so the process of reporting state with this data point included seems to be your most straightforward solution - please let me know if I’m oversimplifying here.
For the data you are accessing in the the AWS database, is this device data, metadata for the devices, or static information about the devices? What kind of integration are you looking for with your CRM/ERP system?
Thanks,
@Aidan_Zebertavage