0

I have decided to use an XFormat Node to grab my JSON POSTFIELDS from an API invoke using PHP. Below is the result of the XML data transformed from the JSON string to a XMLDocument:

<root>
  <salesValue>5000</salesValue>
  <authorId>2</authorId>
</root>

Reading from https://developers.flowgear.net/kb/Node:XPath_Match I came up with the following xpaths to grab those values am interested in and inject them on my SQL Query:

  • salesValue:root/salesValue
  • authorId:root/authorId

I have chosen XML as my escaping value for that property not sure which one it should be. The error I am getting is:

(XFormat 1.0.0.1): Namespace prefix 'salesValue' is not defined.

I guesss the issue is with how I have formatted my xpath in an attempt to grab those values. The SQL Query in the expression property of my XFormat node is shown below:

SELECT `Book`.`id` , `Book`.`name` , `Book`.`isbn` , `Book`.`quantity_in_stock` , `Book`.`price`      , (`Book`.`quantity_in_stock` * `Book`.`price`) AS `sales`, 
concat(`Author`.`name`, ' ', `Author`.`surname`) AS `author`  FROM `books` AS `Book` LEFT JOIN     authors AS `Author` ON ( `Book`.`author_id` = `Author`.`id` ) 
WHERE  (`Book`.`quantity_in_stock` * `Book`.`price`) > {salesValue} AND `Book`.`author_id` = "   {authorId}"

Should I have these values injected in that query I will be able to move forward. Below is the script I use to invoke the WORKFLOW via an API:

              try{
    $results = invokeFlowgear("https://domain.flowgear.io/authorbooksaleslist", "login", "passwrd", 30,
       array(
        'salesValue' => 5000.00,
        'authorId' => 2
     ));

    var_dump($results);


          }catch(Exception $exc){ print $exc->getMessage(); }

Thank you in advance...

scruffycoder86
  • 527
  • 1
  • 5
  • 24

2 Answers2

1

The values in your custom properties should only contain the xpaths, and the names of the custom properties should match your placeholders in the Expression.

You can find the documentation at https://developers.flowgear.net/kb/Node:XFormat#Examples

Skillie
  • 138
  • 7
0

The address of an element in Xpath can have up to three parts:

  1. A local name or * (for all) elements: foo, html - This is mandatory
  2. A namepspace prefix/alias: n1:foo, xhtml:html - No prefix, means no namespace
  3. An axis defining the initial list of elements: children::foo, following-sibling::xhtml:div- default is children

Your XML has no namespaces. It is just wellformed. So providing the 'salesValue' or 'authorId' as namepace prefix is wrong.

Addressing the values from the document root:

  • /root/salesValue
  • /root/authorId

I think the test1: in the example the linked page is just to provide an identifier to the Xpath expression and not a part of it.

ThW
  • 19,120
  • 3
  • 22
  • 44