Querying a database

OL Connect Professional General
1

Hello Everyone,

I receive a XML file in the datamapper. I would like to know if I can querying a database with an element contained in the XML file.

For example, a processus starts with a http server input. In the XML file created, there is an invoice number. How to query a database with this number ?

Thanks a lot for your help

Tenalp

2

In the Workflow tool, use a PlanetPress Database task and specify a custom query (which allows you to enter variable parameters). You can also specify the type of output you want for the query (CSV, XML, etc.). You should tehn passs that output file to the Connect DataMapper.

There should be several posts on how to do this in the PlanetPress Suite user forums (UBB Message - Objectif Lune Tech Support Self Help)

3

Hi Phil,

Thanks for your reply. That’s I’ve done for the moment.

But since Planet Press Connect is able to deal directly with databases “http://learn.objectiflune.com/planetpress-connect/datamapper/filesettings/dbasettings#”, I believed I could query a database with a WHERE clause.

It’s a shame to not be able to get, at least JobInfos in the SQL query designer.

Kind regards

Tenalp

4

Yes, this is already on our TODO list.