Summary
How it works
Crystal Reports
Date
COPY_ARRAY
IS_WEEKEND
Decimal
COPY_ARRAY
Development
LINK_OPEN
VALIDATE
VALIDATE_TRANSACTION
VIEW_SCREEN
Integer
COPY_ARRAY
Short Integer
COPY_ARRAY
File
CREATE_DIRECTORY
CSV_TO_XLSX
DEL_DIRECTORY
DOWNLOAD
GET_COMPLETE_NAME
GET_EXTENSION
GET_HASH
GET_NAME
LIST_DIRECTORIES
LIST_FILES
PATH_TO_VOLUME
UNZIP
UPLOAD
VOLUME_TO_PATH
ZIP
FTP
DELETE
DOWNLOAD
LIST
UPLOAD
HTTP
REQUEST
Image
GENERATE_CODE
IMAP
LIST_DIRECTORIES
Json
COUNT
DEL_KEY
GET_KEYS
GET_ONE
GET_POS_KEY
GET_TYPE
GET_VALUE
SET_VALUE
TO_ARRAY
MongoDB
QUERY
SMS
SEND
SMTP
SEND_EMAIL
Stock
GET_AVAILABLE_QTY
GET_COST
Text
COPY_ARRAY
COUNT_OCCURRENCES
HTML_DECODE
HTML_ENCODE
HTML_TO_TXT
IS_NUMERIC
LINK_DECODE
LINK_ENCODE
RANDOM
REPLACE
RTF_TO_TXT
SPLIT
TO_BASE64
User
CHECK_PASSWORD
Sale
CLOSE_ORDER
GET_PRICE
VALIDATE_DELIVERY
func X3.EN_HTTP_REQUEST(Clbfile URL_IN, Char METHOD_IN, Clbfile FILE_IN, Clbfile GET_KEYS_IN, Clbfile GET_VALS_IN, Clbfile POST_KEYS_IN, Clbfile POST_VALS_IN, Clbfile HEADERS_KEYS_OUT, Clbfile HEADERS_VALS_OUT, Clbfile COOKIES_KEYS_OUT, Clbfile COOKIES_VALS_OUT, Clbfile BODY_OUT) : Integer
Allows you to launch an HTTP request to open a page or make a REST or SOAP API call
- URL_IN Clbfile URL of the resource to query WITHOUT GET parameters (Ex : https://www.google.com/search)
- METHOD_IN Char Method to use (POST, GET, PUT, DELETE, HEAD, CONNECT, OPTIONS, TRACE, PATCH)
- FILE_IN Clbfile Full path or volume to the file to be sent
- GET_KEYS_IN Clbfile Table of keys for GET parameters to send
- GET_VALS_IN Clbfile Table of GET parameter values to send
- POST_KEYS_IN Clbfile Table of POST parameter keys to send
- POST_VALS_IN Clbfile Table of POST parameter values to send
- HEADERS_KEYS_OUT Clbfile Table of HEADER parameter keys to send AND received once the request is executed
- HEADERS_VALS_OUT Clbfile Table of HEADER parameter values to send AND received after the request is executed
- COOKIES_KEYS_OUT Clbfile Table of COOKIES parameter keys to send AND received once the request is executed
- COOKIES_VALS_OUT Clbfile Table of COOKIES parameter values to be sent AND received once the request is executed
- BODY_OUT Clbfile Body to send AND body received once the request is executed
Examples
# Retrieving a Microsoft login token or displaying cookies, headers, and bodies in case of error
Local Clbfile URL_IN(0)
Local Char METHODE_IN(7)
Local Clbfile FICHIER_IN(0)
Local Clbfile GET_CLES_IN(0)(20), GET_VALS_IN(0)(20)
Local Clbfile POST_CLES_IN(0)(20), POST_VALS_IN(0)(20)
Local Clbfile ENTETES_CLES_OUT(0)(20), ENTETES_VALS_OUT(0)(20)
Local Clbfile COOKIES_CLES_OUT(0)(20), COOKIES_VALS_OUT(0)(20)
Local Clbfile CORPS_OUT(0)
Local Integer CODE_HTTP, Y
[L]URL_IN = "https://login.microsoftonline.com/XXXX-XXXX-XXXX-XXXX-XXXX/oauth2/v2.0/token"
[L]METHODE_IN = "POST"
[L]POST_CLES_IN(0) = "grant_type" : [L]POST_VALS_IN(0) = "client_credentials"
[L]POST_CLES_IN(1) = "client_id" : [L]POST_VALS_IN(1) = "XXXX-XXXX-XXXX-XXXX-XXXX"
[L]POST_CLES_IN(2) = "client_secret" : [L]POST_VALS_IN(2) = "XXXX~XXXX~XXXX"
[L]POST_CLES_IN(3) = "scope" : [L]POST_VALS_IN(3) = "https://graph.microsoft.com/.default"
# Launching the query
[L]CODE_HTTP = func X3.EN_HTTP_REQUEST(URL_IN, METHODE_IN,
& FICHIER_IN,
& GET_CLES_IN, GET_VALS_IN,
& POST_CLES_IN, POST_VALS_IN,
& ENTETES_CLES_OUT, ENTETES_VALS_OUT,
& COOKIES_CLES_OUT, COOKIES_VALS_OUT,
& CORPS_OUT)
# If not OK (CODE <> 20X) we want the details
If [L]CODE_HTTP < 200 | [L]CODE_HTTP >= 300
For Y=0 To dim(ENTETES_CLES_OUT)-1
If ENTETES_CLES_OUT(Y) <> ""
Infbox "Header : " + ENTETES_CLES_OUT(Y) + ": " + ENTETES_VALS_OUT(Y)
Else
Break 1
Endif
Next
For Y=0 To dim(COOKIES_CLES_OUT)-1
If COOKIES_CLES_OUT(Y) <> ""
Infbox "Cookie : " + COOKIES_CLES_OUT(Y) + ": " + COOKIES_VALS_OUT(Y)
Else
Break 1
Endif
Next
Call AFFMES("Body : " + CORPS_OUT) From GESECRAN
Else
# Retrieving the token in the Json
Call AFFMES(func X3.FR_JSON_RECUP_VALEUR(CORPS_OUT, "access_token")) From GESECRAN
Endif