SQL Server Query Publisher

This publisher is very similar to the SQL OPENJSON publisher but with some added functionality.

If you require data to be pushed in with a Created At Date, you can specify this column in the “Create Date Field Name” input and the current date the publisher ran will get added here. Similarly, you can add a GUID to an ID field if required, just add the field name into “Create GUID Code Field Name” Lastly you can choose to update a table instead of adding a new line. To do this you will need to have “Perform Update” marked as Yes and then input the name of the field utopia can use to identify the field it needs to update, add this to “Identity Field Name”.