Confirming Invalid Format: Troubleshooting Data Rows in File | Northern Trail Outfitters
Question
Northern Trail Outfitters runs a nightly automation consisting of a File Transfer and a File Import. Following an update from the engineering team, the automation began failing. The Marketing Cloud admin suspects the CSV file now has an invalid format.
How could the admin receive a file of the bad data rows to confirm this theory?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C.B
The most appropriate solution for the Marketing Cloud admin to receive a file of the bad data rows to confirm their theory would be to move the File Transfer to its own automation and include a notification email address.
Explanation: Moving the File Transfer to its own automation allows the admin to specify a separate notification email address for any errors or warnings that may occur during the transfer. This email address can be the admin's own email or a team email distribution list. When the transfer fails due to a file format issue, the notification email will contain the details of the error, including the name and location of the CSV file, as well as the reason for the failure.
This approach helps the Marketing Cloud admin identify the exact CSV file that is causing the problem, so they can investigate and confirm whether the file has an invalid format. If the issue is with the file format, the admin can work with the engineering team to update the file and re-run the automation.
On the other hand, updating the Import definition or moving the Import definition to its own automation and including a notification email address may not provide the necessary details to confirm the theory about the CSV file's invalid format. While notifications for failed imports can be sent via email, they may not include specific details about the failed rows or the CSV file itself, making it more difficult for the admin to identify and isolate the issue.
In conclusion, moving the File Transfer to its own automation and including a notification email address would be the best option for the Marketing Cloud admin to receive a file of the bad data rows to confirm their theory about the CSV file's invalid format.
