Hello, I am connecting my KoboToolbox project to Excel using Power Query through the Kobo API. I noticed that attachment URLs (photo questions) are sometimes generated as separate rows instead of appearing in the same row as the parent submission. For example, a submission is correctly displayed on one row, but the attachment link appears on the next row with an empty index and other empty fields.
This is also creating problems when synchronizing data between Kobo and Excel. Could this issue be caused by the extra empty row generated for the attachment? How can I prevent attachments from being exported as separate rows and ensure they remain linked to their parent submission?
