MySQL sync: no matches for field item_id
I'm trying to sync Podio to MySQL via Podio Workflow Automation. The connection to my database works fine. I can connect the Hash Checksum to the column I created (hash - varchar(32).
However, it does not find a match for the item_id column. Here's my create table code:
CREATE TABLE `sprints` (
`ID` int AUTO_INCREMENT PRIMARY KEY,
`item_id` int unsigned,
`hash` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
I tried multiple setups, and this code creates three INT columns. I would expect ID as well as item_id would work, but this is the result:
As you see, the hash match works fine:
Any ideas on what I'm doing wrong here?
Thanks in advance!
Please sign in to leave a comment.