Hi @Nils Pottbäcker ,
Can you give me bit more details?
I have a bot that gets a PDF and an order number via email and the PDF has to be attached to an order in a program using the order number.
Therefore I would like to query my MSQL database from this program whether this order already exists.
Can you understand that?
Yes you can Query the result from the DB and using Loop command you can check for the required value and convert to the required format.
You can use the Database Action Package to connect with MS SQL and using a Where clause, check whether the item exists or not, i.e., check if the datatable queried back is empty or not:
SELECT * FROM [TableName]
WHERE [PURCHASE_ORDER] = $nPurchaseOrder.Number:toString$Is this what you were looking for?
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.