Generating an email with multiple item output.

KnowledgeSync web-based

I'm attempting to create a system for my employees to email in data in a specified format that will return data from my ERP.

I so far have:

  1. My email account inbox being monitored by KnowledgeSync
  2. Two queries that are linked and working (for individual items)
  3. An HTML email that responds properly with one item

The issue that I'm hoping to get help with is when I want to return data on mulitple items. 

I'm hoping someone has had luck with getting this to work. I believe the only way to get it to work is to have the incoming request data in a CSV format i.e.

Part Number: 6101098, 6101099, 6101029

This would allow the primary query to pull the data after Part Number:, and feed it to the secondary query, which would then build the email in the event using {BEGIN REPEAT} and {END REPEAT}

Has anyone had success doing this?

This was an attempt that only read the first number, but repeated it 4 times.

Any help would be appreciated. Please let me know what other information that I can provide.

  • +1
    Verified Answer

    Hi Lonnie,

    I've seen this behavior before writing queries and it was due to the SQL coding, likely a join or how those values are being passed into the query.

    As this level of customizations are not supported you could enlist the assistance of your BP, or your DBA to verify query parameters, and syntax.

    Alternatively you can also ask this in the developer forum.

    Thanks