Hello,
I have a site running 9.14.9 and we are using BC odata for integration and every endpoint is returning data, but none of them are commiting data to the site. Every log file looks similar to this with the url changing to reflect each endpoint:
For this particular endpoint when using the URL from the log in Postman to see what data is returning I get these results:
"value": [
{
"@odata.etag": "W/\"JzIwOzExMjQ2MDY5NzIwNDM2OTAyMzY5MTswMDsn\"",
"assortmentPermissionAssortmentId": "CP0010",
"assortmentPermissionAccessUserId": "8376",
"id": "CP0010-8376"
},
{
"@odata.etag": "W/\"JzIwOzExMjQ2MDY5NjM0MDYxMjY3MTM3MTswMDsn\"",
"assortmentPermissionAssortmentId": "CP0010",
"assortmentPermissionAccessUserId": "8470",
"id": "CP0010-8470"
}
]
}
Neither of these records are in the database on the EcomAssortmentPermissions as expected since "No rows were imported". This happens on every activity, products, customer, variants, logins, etc.
I have confirmed with each one that the URL from the log works and is returning data in Postman. I have also rebuilt each job both with the endpoint provider and the BC provider and they net the same result of No row being imported. The primary keys are set on the jobs and the settings in the destination providers have been checked to ensure none of the setttings such as "update existing rows only" are checked.
Please advise on how to get the data that is returning from the odata api into the dw database.
