You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Describe the bug
requirement is get the data from postgres database and alert the message/notify to teams.
here is my yaml workflow file.
Attached the error message. To Reproduce
Steps to reproduce the behavior:
id: query-postgres-and-notify-teams
description: Query postgres and notify teams
triggers:
Describe the bug
requirement is get the data from postgres database and alert the message/notify to teams.
here is my yaml workflow file.
Attached the error message.
To Reproduce
Steps to reproduce the behavior:
id: query-postgres-and-notify-teams
description: Query postgres and notify teams
triggers:
type: alert
owners: []
services: []
steps:
provider:
config: '{{ providers.jazzpost }}'
type: postgres
with:
query: SELECT * FROM public.ticketinstance LIMIT 1
actions:
provider:
config: '{{ providers.jazzware }}'
type: teams
with:
message: Got alert from postgres {{ steps.postgres-step.results.name }}
Expected behavior
A clear and concise description of what you expected to happen.
Screenshots
Error during workflow execution
(builtins.TypeError) Object of type datetime is not JSON serializable
[SQL: UPDATE workflowexecution SET results=? WHERE workflowexecution.id = ?]
[parameters: [{'results': {'trigger-teams': [], 'postgres-step': [[('996d081c-6c2d-4439-ba69-0e923fc5354c',
Please help me to fix this issue. thanks.
The text was updated successfully, but these errors were encountered: