ManagedEngine ServiceDesk Plus (Zoho) Connector
Documentation
Version: 2
Documentation
Endpoint

Get Purchase Orders

Name

get_purchase_orders

Description

No description available

Related Tables

PurchaseOrders

Parameters

Parameter Label Required Options Description
There are no parameters

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
id DT_WSTR nvarchar(100) 100 False
owner_email_id DT_WSTR nvarchar(100) 100 False
owner_is_technician DT_BOOL bit False
owner_sms_mail DT_WSTR nvarchar(1020) 1020 False
owner_mobile DT_WSTR nvarchar(50) 50 False
owner_last_name DT_WSTR nvarchar(50) 50 False
owner_user_scope DT_WSTR nvarchar(100) 100 False
owner_sms_mail_id DT_WSTR nvarchar(1020) 1020 False
owner_phone DT_WSTR nvarchar(1020) 1020 False
owner_employee_id DT_WSTR nvarchar(50) 50 False
owner_name DT_WSTR nvarchar(50) 50 False
owner_id DT_WSTR nvarchar(100) 100 False
owner_photo_url DT_WSTR nvarchar(500) 500 False
owner_is_vip_user DT_BOOL bit False
owner_department DT_WSTR nvarchar(1020) 1020 False
owner_first_name DT_WSTR nvarchar(50) 50 False
owner_job_title DT_WSTR nvarchar(1020) 1020 False
template_inactive DT_BOOL bit False
template_name DT_WSTR nvarchar(100) 100 False
template_id DT_WSTR nvarchar(100) 100 False
required_date_display_value DT_WSTR nvarchar(50) 50 False
required_date_value DT_WSTR nvarchar(100) 100 False
total_price_display_value DT_WSTR nvarchar(50) 50 False
total_price_currency_symbol DT_WSTR nvarchar(50) 50 False
total_price_value DT_R8 float False
total_price_secondary_currency_display_value DT_R8 float False
total_price_secondary_currency_currency_symbol DT_WSTR nvarchar(50) 50 False
total_price_secondary_currency_value DT_R8 float False
custom_id DT_WSTR nvarchar(50) 50 False
sites DT_WSTR nvarchar(500) 500 False
requested_by_email_id DT_WSTR nvarchar(100) 100 False
requested_by_is_technician DT_BOOL bit False
requested_by_sms_mail DT_WSTR nvarchar(1020) 1020 False
requested_by_mobile DT_WSTR nvarchar(50) 50 False
requested_by_last_name DT_WSTR nvarchar(50) 50 False
requested_by_user_scope DT_WSTR nvarchar(100) 100 False
requested_by_sms_mail_id DT_WSTR nvarchar(1020) 1020 False
requested_by_phone DT_WSTR nvarchar(1020) 1020 False
requested_by_employee_id DT_WSTR nvarchar(50) 50 False
requested_by_name DT_WSTR nvarchar(50) 50 False
requested_by_id DT_WSTR nvarchar(100) 100 False
requested_by_photo_url DT_WSTR nvarchar(500) 500 False
requested_by_is_vip_user DT_BOOL bit False
requested_by_department DT_WSTR nvarchar(1020) 1020 False
requested_by_first_name DT_WSTR nvarchar(50) 50 False
requested_by_job_title DT_WSTR nvarchar(1020) 1020 False
vendor_name DT_WSTR nvarchar(50) 50 False
vendor_description DT_WSTR nvarchar(100) 100 False
vendor_currency_symbol DT_WSTR nvarchar(50) 50 False
vendor_currency_code DT_WSTR nvarchar(50) 50 False
vendor_currency_exchange_rate DT_WSTR nvarchar(50) 50 False
vendor_currency_name DT_WSTR nvarchar(50) 50 False
vendor_currency_id DT_WSTR nvarchar(100) 100 False
vendor_id DT_WSTR nvarchar(100) 100 False
name DT_WSTR nvarchar(50) 50 False
currency_symbol DT_WSTR nvarchar(50) 50 False
currency_code DT_WSTR nvarchar(50) 50 False
currency_exchange_rate DT_WSTR nvarchar(50) 50 False
currency_name DT_WSTR nvarchar(50) 50 False
currency_id DT_WSTR nvarchar(100) 100 False
created_date_display_value DT_WSTR nvarchar(50) 50 False
created_date DT_DBTIMESTAMP datetime False
status_name DT_WSTR nvarchar(100) 100 False
status_id DT_WSTR nvarchar(100) 100 False
required_date DT_WSTR nvarchar(1020) 1020 False
If the column you are looking for is missing, consider customizing ManagedEngine ServiceDesk Plus (Zoho) Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use ManagedEngine ServiceDesk Plus (Zoho) Connector in API Source component to read data or in API Destination component to read/write data:

Read from PurchaseOrders table using API Destination

This Endpoint belongs to PurchaseOrders table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

ManagedEngine ServiceDesk Plus (Zoho)
PurchaseOrders
Select
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Get purchase orders 

SELECT * FROM get_purchase_orders

List purchase orders

This example shows how to list purchase orders. 

SELECT * FROM PurchaseOrders

Read purchase order details by ID

This example shows how to read extended information about a single purchase order 

SELECT * FROM PurchaseOrders Where id=111112345

get_purchase_orders endpoint belongs to PurchaseOrders table(s), and can therefore be used via those table(s).

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Get purchase orders 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_purchase_orders';

EXEC (@MyQuery) AT [LS_TO_MANAGEDENGINE_SERVICEDESK_PLUS_ZOHO_IN_GATEWAY];

List purchase orders

This example shows how to list purchase orders. 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM PurchaseOrders';

EXEC (@MyQuery) AT [LS_TO_MANAGEDENGINE_SERVICEDESK_PLUS_ZOHO_IN_GATEWAY];

Read purchase order details by ID

This example shows how to read extended information about a single purchase order 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM PurchaseOrders Where id=111112345';

EXEC (@MyQuery) AT [LS_TO_MANAGEDENGINE_SERVICEDESK_PLUS_ZOHO_IN_GATEWAY];

get_purchase_orders endpoint belongs to PurchaseOrders table(s), and can therefore be used via those table(s).