Query an XML string using an XPath expression

The “Query XML” action returns data from a XML string based upon a XPath expression.

Provide a string of XML data and an XPath expression and it will return one or more results matching the expression.

Parameters

TitleNameTypeDescription

XML

input

string

Source XML string

Query Expression

query

string

XPath expression

Response

Status

TitleNameTypeDescription

Success

Result

result

string

XML string

Failure

Result

result

string

Error description

Integrate the "Query XML" function into a workflow or app with the platform of your choice:

How to query an XML string using an XPath expression with Microsoft Power Automate

Instructions

  1. In the Flow designer, click the “+” icon to insert a new action.
  2. Select the “Data – Query XML” action under PowerTools in the “Choose an operation” dialog.
  3. Insert the necessary values or variables in each input field.
  4. Execute the flow.

Example

Video

How to query an XML string using an XPath expression with Microsoft Power Apps

Instructions

  1. Add the PowerTools connector from the Data menu.
  2. In the formula for the control, variable or element, type “ApptigentPowerTools.QueryXML().result”. Within the parentheses, enter the field, control or variable that contains the source collection.
  3. Preview or run the app.

Example

Image Coming Soon

Video

How to query an XML string using an XPath expression with Nintex

Instructions

  1. Locate the “Apptigent PowerTools” group in the actions navigator then drag and drop the “Data – Query XML” action onto the design surface.
  2. Insert the necessary values or variables in each input field.
  3. Assign the result to a variable.
  4. Test the workflow.

Example

Video

How to query an XML string with another Platform or Custom Code

Instructions

If your platform is not listed and it supports Open API (Swagger) extensions, import the API Definition document from the Developer Edition product on our Customer Portal at https://portal.apptigent.com/product (look for the Open API link at the top of the PowerTools Developer API definition page). Invoke the desired actions in your app or workflow design tool, supplying values for the listed parameters. Refer to the developer documentation on the Customer Portal for details on input and output formats.

If you are developing a custom app, execute a RESTful POST operation to the /CountCollection endpoint in your application code or use the pre-generated client scaffolding from our Github repo at https://github.com/apptigent/powertools. Be sure to include your API Key (Client ID) in the header using the “X-IBM-Client-Id” key/value pair. The body should be a well-formed JSON object with the parameter label(s) and value(s) in the specified format. Refer to the API documentation at https://portal.apptigent.com for more information.

Example

const request = require('request');

const options = {
  method: 'POST',
  url: 'https://connect.apptigent.com/api/utilities/QueryXML',
  headers: {
    'X-IBM-Client-Id': 'REPLACE_THIS_KEY',
    'content-type': 'application/json',
    accept: 'application/json'
  },
  body: {
    input: '{"properties": [{"name":"ID","value":"1234"},{"name":"Title","value":"Some Title"}]}',
    query: '$.properties[?(@.name == "ID")].value'
  },
  json: true
};

request(options, function (error, response, body) {
  if (error) throw new Error(error);

  console.log(body);
});
FREE WHITEPAPER
Maximizing the ROI of Low-Code Automation Tools
Unlock the potential of low-code automation tools to drive digital transformation and maximize ROI. Our whitepaper explores the benefits, challenges, and strategic framework for implementing these platforms, featuring real-world case studies from top organizations.