Developer forum

Forum » Integration » Integration Activity - using product category fields as conditionals not working

Integration Activity - using product category fields as conditionals not working

E-mail notifications
Jon Thorne
Jon Thorne
Reply
Posted on 09/08/2026 10:37:09

I am having an issue using product category fields as conditionals in my integration activity.

I only want to export to BC items with a particular flag set. Source is Ecom provider and destination is OData.

Error returned: Failed to open sqlSourceReader. Reason: Invalid column name 'ProductCategoryPublishingNZReady_for_BC_NZ'.

This is the condition I have setup. Am I doing something wrong? Or does this not work yet?


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 10/08/2026 08:53:49
Reply

Hi Jon,
that is a bug, the category fields are exposed as pseudo-columns named ProductCategory|{CategoryId}|{FieldId} and they are skipped at conditionals. When a category field is used only in a conditional (not also mapped to a destination column), the bracketed name gets referenced in SQL, but the join that would actually create that column was never added → "Invalid column name."

The workaround for now is to add an actual column mapping for that same category field (map it to any destination column, even one you don't otherwise need) alongside your conditional. That forces CategoriesColumns to be populated, which builds the correct join, and the conditional will then resolve correctly.

BR, Dmitrij

 

You must be logged in to post in the forum