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
Load an HTML document from a string
Parameters
domId: The DOM id - string - required
html: The HTML - string - required
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
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 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
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
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
Often used with
concat_var · html close · html element · html exist · html parse · html show · string trim
concat_var · html close · html element · html exist · html parse · html show · string trim
html close <domId>
Description
Close a document
Close a document
Parameters
domId: The DOM id - string - required
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
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 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
Close all documents
admin
html close_all;
mentdb
2
Often used with
html close · html element · html exist · html load_from_str · html parse · html show · json doc · json iarray
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
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
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 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
To check if a document already exists
Parameters
domId: The DOM id - string - required
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
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 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
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
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
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 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)
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
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
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
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
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
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
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 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
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
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
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
json doc · json iarray · string regexp_replace · cm get · execute · string trim · not · string regexp_extract
