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>