Advanced Builtin Functions

Status
Not open for further replies.
Here you can use some Pabbly Connect’s builtin functions to simplify your integration

NameExample CallExpected Result
Get current date-time in encrypted UTC format{{gc_curr_date_time}}2021-09-21T07:14:57+00:00
Get current date-time in encrypted UTC format (with addition of 3min){{gc_curr_date_time_plus_3m}}2021-09-21T07:20:37+00:00
Unix TimeStamp UTC{{pc_utc_timestamp_now}}1627999296
Unix TimeStamp in User's Local Time Zone{{pc_local_timestamp_now}}1627979363
Human-readable date and time in UTC{{pc_utc_human_now}}MM/DD/YY hh:mmAM/PM (Ex:, 01/15/21 06:05PM).
Human-readable date and time in Local Time Zone{{pc_local_human_now}}MM/DD/YY hh:mmAM/PM (Ex:, 01/15/21 06:05PM).
Server Date in UTC format{{pc_utc_date_now}}YYYY-MM-DD (Ex: 2021-08-23)
Server Date in local format{{pc_local_date_now}}YYYY-MM-DD (Ex: 2021-08-23)
Used for boolean value as "true"{{##boolean:true##}}TRUE
Used for boolean value as "false"{{##boolean:false##}}FALSE
Used for assigning null value{{skip}}null will be passed as a value in JSON
Removes a key value from the Raw JSON if field is blank{{pc_skip_field}}Dynamic JSON (https://drive.google.com/file/d/17wYnIiK0TTPu09ZPMxXT-B4bRUJM81mj/view?usp=drivesdk)
Removes object from the Raw JSON if child fields are blank{{pc_skip_field_with_parent}}Dynamic JSON (https://drive.google.com/file/d/1gli7e7cN1SWFlq_DegXJKNXEkEoOPE6w/view?usp=sharing)
Used for assigning blank value{{blank}}Blank space will be added as value in JSON
Used for assigning the blank space{{space}}Space will be added as value
Used for assigning random hex encrypt value{{hex_enc_bytes}}4658514243455a58
Skip array fieldsprovide this in default value of array key : {"id":"{{pc_skip_field_with_parent}}"}Dynamic JSON (https://drive.google.com/file/d/1II_fWRl03Cq_-V0BaXJpLa9u54z31QQh/view?usp=drivesdk)


Here are some examples of builtin function -

  1. {{skip}} - Automatically add null as default value if the parameter value is empty. You can set {{skip}} as default value under default value field by clicking on the parameter’s gear icon.
1635830026724.png

Parameter setting with {{skip}} in default value.​

1635830175967.png

This is how the final request body raw JSON will be generated -​
1634817077797.png

2. {{blank}} - Automatically add blank value if the parameter value is empty. You can set {{blank}} as default value under default value field by clicking on the parameter’s gear icon.​
1635830129868.png
Parameter setting with {{blank}} in default value.​
1635830227387.png
This is how the final request body raw JSON will be generated -​
1634817591675.png
3. {{##boolean:true##}} - Used for boolean value as "true" similarly you can use {{##boolean:false##}} for boolean false value.​
1635830258825.png

Parameter setting with {{##boolean:true##}} and {{##boolean:false##}} in default value.​
1635830276847.png
This is how the final request body raw JSON will be generated -​
1634818138377.png

4. {{pc_skip_field}} - Automatically omit fields in the request body that are empty.​

1635830300109.png
Parameter setting with {{pc_skip_field}} in default value.​
1635830529341.png
This is how the final request body raw JSON will be generated -​
1634818905183.png
 

Attachments

  • 1634817041916.png
    1634817041916.png
    24.4 KB · Views: 28
  • 1634817058168.png
    1634817058168.png
    21 KB · Views: 28
  • 1634817323251.png
    1634817323251.png
    20.4 KB · Views: 14
  • 1634817575682.png
    1634817575682.png
    20.4 KB · Views: 21
  • 1634817916236.png
    1634817916236.png
    28.8 KB · Views: 21
  • 1634817935480.png
    1634817935480.png
    31.2 KB · Views: 21
  • 1634818856639.png
    1634818856639.png
    27.9 KB · Views: 16
  • 1634818890340.png
    1634818890340.png
    21.2 KB · Views: 21
Last edited:
Status
Not open for further replies.
Top