Share via

Catalog Web Service and SetJoin API Configuration

  • Article

I was debugging why the Catalog Web Service was not working with my Set Join API and found that the documentation was pointing to the runtime site web.config values (which is incorrect). What this means is the Catalog Web Service web.config is configured differently slightly different. I worked with the Product Group and we found the solution. This will be fixed in the next doc refresh but I thought I post here just in case someone is interested.

You will need to add a Join table name for every SQL object you whish to join. This is done for security reason you don’t want just anyone to be able to join to whatever table. The other options are passed using the JoinTableInformation object.

 

<

JoinTable>
<JoinTable>joinTable_A</JoinTable>
<JoinTable>joinTable_B</JoinTable>
</JoinTable>

Comments

  • Anonymous
    April 01, 2008
    The official documentation for the commendable SetJoin API in commerce Server 2007 seems more like a

  • Anonymous
    April 01, 2008
    The official documentation for the commendable SetJoin API in commerce Server 2007 seems more like a

  • Anonymous
    April 18, 2008
    The comment has been removed

  • Anonymous
    April 23, 2008
    You need to give the application pool account for the web service access to the MSCS_Admin database and  Product Catalog. -Max