• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

  • Important: Any reported problems and issues with your integration will be reported to you and we will encourage the app developers help to resolve those integration issues.

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 date-time a day ago from the Current Date-time in encrypted UTC format{{pc_yesterday_curr_date_time}}2021-09-20T07:20:37+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: 57
  • 1634817058168.png
    1634817058168.png
    21 KB · Views: 61
  • 1634817323251.png
    1634817323251.png
    20.4 KB · Views: 44
  • 1634817575682.png
    1634817575682.png
    20.4 KB · Views: 52
  • 1634817916236.png
    1634817916236.png
    28.8 KB · Views: 54
  • 1634817935480.png
    1634817935480.png
    31.2 KB · Views: 54
  • 1634818856639.png
    1634818856639.png
    27.9 KB · Views: 46
  • 1634818890340.png
    1634818890340.png
    21.2 KB · Views: 51
Last edited:
Status
Not open for further replies.
Top