Writing a Custom Script Using Python

You need working knowledge of:

  • JSON 
  • Python

 

Custom Script File Structure

  1. Import required packages 
  2. Get input arguments
  3. Implement the logic 
  4. Return JSON

 

Frequently Used Packages

 

Package

Usage

Sys

Fetches the input arguments

json

Manipulates JSON data

requests

Makes API calls

datetime

Transforms time from milliseconds to the required date format

 

Getting Input Arguments

The script file arguments can be fetched using sys.argv[index] where index starts from 1 to the number of arguments passed.

When the argument passed is $COMPLETE_V3_JSON_FILE (the path to the file containing the request JSON), the JSON file can be read using the following snippet:

file_Path = sys.argv[1]
with open(file_Path) as data_file:
data = json.load(data_file)

 

Implementing the Logic

Snippet to make API call:

with requests.Session() as s:
url = 'api_url'
r = s.post(url,verify=True, data=post_data,headers=headers)

 

Construct the api_url, post_data and headers as required.

Snippet to transform time from millisec to required date format:

date = datetime.datetime.fromtimestamp(int(millisec)/1e3).strftime('%d %b %Y, %H:%M:%S')

 

Constructing Return JSON

A sample JSON such as {"key":"value"} construction:

json = {}

json["key"] = "value"

print(json)

 

A sample JSON array such as [{"key":"value"}] construction:

json = {}

json["key"] = "value"

result = []

result.append(json)

print(result)

 

 

<<Sample Scripts>>

 

 

© 2025 Zoho Corporation Pvt. Ltd. All rights reserved.