I reported this to support but have no idea how long it will take to get a response and wanted to ask the community if they knew what was going on:
I created a local app which processes a CSV file. It loops through the rows and follows the following steps using API calls:
- List itemin my local APP I created a loop through a CSV file and read the rows. For each row I do the following with the API:
- Check if item exists with same name using search for item with name column
- If doesn’t exist Add it as an Item and use specific columns from Row to populate specified column IDs
- Check if SubItem Exists
- If not add a SubItem to the Item created in step 2 using specific columns from Row to populate specified column IDs
All of these steps receive responses of success and IDs for whatever is created.
I suspected items were missing, often watch the browser and there would be an item/subitem sum I looked at as it grew in the import. It would complete and the page would refresh at some point and count would be less than it was when completed the process of looping through the CSV rows. FYI I am not importing the CSV directly because I am performing calculations like Due Dates and who to assign and the format change of many of columns wouldn’t be feasible.
After I added step 6. Verify Item Exists, I found around the same count of items/subitems created, it fails to find the Item. I have tried API to search for item using column name and simply getting a list of items and their names on the board and tried filtering the board in a browser manually. For all, the item is missing. Usually it’s about 100 api queries after started but that’s a guess and not exact. The Item and SubItem actually show up in the browser and no matter how long I wait, if I hit refresh it disappears as though I did not add them. It is not item specific because if I start import again it starts with the missing item and that ends up in the next failure still being there. It fails on another item.
I could create a step to add them again however this would be mistake since it is only a band-aid.
Let me repeat just in case it is missed: the Item is added gets ID of item from API and adds Subitem getting the ID successfully. It is only after I verify the item exists in the board through API I get any indication it’s not there anymore. Before I addedStep 5 Verify, I had no idea item was missing. I can create a new board from a template without any items on it and same issue occurs.
I have reviewed Activity/History for the Board and the activity shows the Item and SubItem was added but nothing else related to them like being deleted or moved.
Any help is greatly appreciated! This is bizarre for sure. I have a loom video I can send if desired showing it.