HTML
Load HTML documents from a string or a URL, select elements with jsoup syntax and loop over them, and loop over JSON objects and arrays with json parse_obj and json parse_array. Typical uses: extract data from a web page, read a table from an HTML report.
html load_from_strhtml load_from_urlhtml closehtml close_allhtml showhtml existhtml elementhtml parsejson parse_objjson parse_array

html load_from_str <domId> <html>


Description

    Load an HTML document from a string

Parameters

    domId:   The DOM id - string - required
    html:   The HTML - string - required
admin
html load_from_str "domId1" "...";
mentdb
1
Used in use cases (10 recipes)

    Web application developer › Generate an ajax form and test it
    Screen & UI developer (sajax) › Inline contact form with text, mail, tel, textarea and hidden fields
    XML, HTML & Word integrator › Scrape exchange rates from an HTML page
    Web application developer › Build the menu and test who sees what
    Screen & UI developer (sajax) › Modal booking form with date, datetime, time and number pickers
    Screen & UI developer (sajax) › Preferences form with color, range, password and file upload
    and 4 more in the Use cases
Often used with

    html close  ·  html parse  ·  concat_var  ·  include  ·  string encode_b64  ·  string regexp_count  ·  string regexp_extract  ·  string length

html load_from_url <domId> <url> <method> <timeout> <jsonHeaders> <jsonCookies> <jsonData>


Description

    Load an HTML document from a URL

Parameters

    domId:   The DOM id - string - required
    url:   The URL - string - required
    method:   The method (GET|POST) - string - required
    timeout:   The timeout (ex: 5000) - number - required
    jsonHeaders:   The JSON key map of headers - string - required
    jsonCookies:   The JSON key map of cookies - string - required
    jsonData:   The JSON key map of data - string - required
admin
html load_from_url "domId1" "https://www.tripadvisor.fr/Hotel_Review-g298470-d1473791-Reviews-LUX_Saint_Gilles-Saint_Gilles_Les_Bains_Arrondissement_of_Saint_Paul.html" "get" 5000 "{}" "{}" "{}";
mentdb
1
Used in use cases (1 recipe)

    Web application developer › Smoke test the login page over HTTP
Often used with

    concat_var  ·  html close  ·  html element  ·  html exist  ·  html parse  ·  html show  ·  string trim

html close <domId>


Description

    Close a document

Parameters

    domId:   The DOM id - string - required
admin
html close "domId1";
mentdb
1
Used in use cases (11 recipes)

    Web application developer › Smoke test the login page over HTTP
    Screen & UI developer (sajax) › Inline contact form with text, mail, tel, textarea and hidden fields
    XML, HTML & Word integrator › Scrape exchange rates from an HTML page
    Web application developer › Generate an ajax form and test it
    Web application developer › Build the menu and test who sees what
    Screen & UI developer (sajax) › Modal booking form with date, datetime, time and number pickers
    and 5 more in the Use cases
Often used with

    html parse  ·  html load_from_str  ·  concat_var  ·  include  ·  string encode_b64  ·  string regexp_count  ·  string regexp_extract  ·  string trim

html close_all


Description

    Close all documents

admin
html close_all;
mentdb
2
Used in use cases (1 recipe)

    XML, HTML & Word integrator › Scrape exchange rates from an HTML page
Often used with

    html close  ·  html element  ·  html exist  ·  html load_from_str  ·  html parse  ·  html show  ·  json doc  ·  json iarray

html show


Description

    To show all open documents

admin
html show
mentdb
["domId1"];
Used in use cases (2 recipes)

    Web application developer › Smoke test the login page over HTTP
    XML, HTML & Word integrator › Scrape exchange rates from an HTML page
Often used with

    html close  ·  html element  ·  html exist  ·  html parse  ·  concat_var  ·  html close_all  ·  html load_from_str  ·  html load_from_url

html exist <domId>


Description

    To check if a document already exists

Parameters

    domId:   The DOM id - string - required
admin
html exist "domId1"
mentdb
1
Used in use cases (2 recipes)

    Web application developer › Smoke test the login page over HTTP
    XML, HTML & Word integrator › Scrape exchange rates from an HTML page
Often used with

    html close  ·  html element  ·  html parse  ·  html show  ·  concat_var  ·  html close_all  ·  html load_from_str  ·  html load_from_url

html element <domId> <jsonDoc> <id>


Description

    To load an HTML element into a JSON object

Parameters

    domId:   The DOM id - string - required
    jsonDoc:   The JSON document id - string - required
    id:   The element id - string - required
admin
html element "domId1" "jsonDoc1" "id"
mentdb
1
Used in use cases (2 recipes)

    Web application developer › Smoke test the login page over HTTP
    XML, HTML & Word integrator › Scrape exchange rates from an HTML page
Often used with

    html close  ·  html exist  ·  html parse  ·  html show  ·  concat_var  ·  html close_all  ·  html load_from_str  ·  html load_from_url

html parse <domId> <jsonDoc> <searchType> <key> <value> <mqlActions>


Description

    To execute actions on HTML elements (JSOUP syntax)

Parameters

    domId:   The DOM id - string - required
    jsonDoc:   The JSON document id - string - required
    searchType:   The search type (TAG | ATTRIBUTE | SELECT | CLASS | ATTRIBUTE_VALUE | CONTAINING_OWN_TEXT | CONTAINING_TEXT | OWN_TEXT_REGEX | TEXT_REGEX | ATTRIBUTE_STARTING | ATTRIBUTE_VALUE_CONTAINING | ATTRIBUTE_VALUE_ENDING | ATTRIBUTE_VALUE_REGEX | ATTRIBUTE_VALUE_NOT | ATTRIBUTE_VALUE_STARTING) - string - required
    key:   The key - string - required
    value:   The value - string - required
    mqlActions:   The MQL actions - string - required
admin
html parse "domId1" "jsonDoc1" "TAG" "a" "" { #Here your MQL source code ...; json select "jsonDoc1" "/text"; json select "jsonDoc1" "/html"; json select "jsonDoc1" "/formVal"; json select "jsonDoc1" "/tagName"; json select "jsonDoc1" "/id"; json select "jsonDoc1" "/nodeName"; json select "jsonDoc1" "/outerHtml"; json select "jsonDoc1" "/ownText"; json select "jsonDoc1" "/wholeText"; json select "jsonDoc1" "/attributes/..."; json select "jsonDoc1" "/classNames[0]"; };
mentdb
1
Used in use cases (11 recipes)

    Web application developer › Smoke test the login page over HTTP
    Screen & UI developer (sajax) › Inline contact form with text, mail, tel, textarea and hidden fields
    XML, HTML & Word integrator › Scrape exchange rates from an HTML page
    Web application developer › Generate an ajax form and test it
    Web application developer › Build the menu and test who sees what
    Screen & UI developer (sajax) › Modal booking form with date, datetime, time and number pickers
    and 5 more in the Use cases
Often used with

    html close  ·  html load_from_str  ·  concat_var  ·  include  ·  string encode_b64  ·  string regexp_count  ·  string regexp_extract  ·  string trim

json parse_obj <docId> <jsonPath> <varKey> <varValue> <mqlActions>


Description

    To execute actions on a JSON object

Parameters

    docId:   The document id - string - required
    jsonPath:   The JSON path - string - required
    varKey:   The key variable (ex: [key]) - string - required
    varValue:   The value variable (ex: [val]) - string - required
    mqlActions:   The MQL actions - string - required
admin
json parse_obj "keyId" "/" "[key]" "[val]" { #Here your MQL source code ...; log trace (concat [key] "=" [val]); };
mentdb
Used in use cases (22 recipes)

    MQL beginner › Loop over the lines of a JSON order
    Backend & web service developer › Health check endpoint for the load balancer
    String & encoding developer › Mail merge: fill a template from JSON data
    Data validation developer › Infer SQL column types from CSV samples
    JSON & document store developer › Extract and clean a config subtree
    Versioning & deployment › One deployment file: scripts and parameters
    and 16 more in the Use cases
Often used with

    json doc  ·  json iarray  ·  json iobject  ·  string contains  ·  json fields  ·  string regexp_extract  ·  string regexp_replace  ·  not

json parse_array <docId> <jsonPath> <varValue> <mqlActions>


Description

    To execute actions on a JSON array

Parameters

    docId:   The document id - string - required
    jsonPath:   The JSON path - string - required
    varValue:   The value variable (ex: [val]) - string - required
    mqlActions:   The MQL actions - string - required
admin
json parse_array "keyId" "/" "[val]" { #Here your MQL source code ...; [val]; };
mentdb
Used in use cases (68 recipes)

    JSON & document store developer › Sort and total a sales array
    Event developer › Refuse a file received twice under two names
    Configuration & connections › Stamp an action with the user, session and process
    Debugging & error handling › Follow an order through the logs with a correlation id
    SQL developer in MQL › Create a table and load rows safely
    CRUD & data API developer › A write API with business rules in one transaction
    and 62 more in the Use cases
Often used with

    json doc  ·  json iarray  ·  string regexp_replace  ·  cm get  ·  execute  ·  string trim  ·  not  ·  string regexp_extract