Reference

Endpoint Get Purchase Order Details

Name

get_purchase_order_details

Description

No description available

Related Tables

PurchaseOrders

Parameters

Parameter Required Options
Name: PurchaseOrderId

Label: PurchaseOrderId

 YES

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
id DT_WSTR nvarchar(100) 100
owner_email_id DT_WSTR nvarchar(100) 100
owner_is_technician DT_BOOL bit
owner_sms_mail DT_WSTR nvarchar(1020) 1020
owner_mobile DT_WSTR nvarchar(50) 50
owner_last_name DT_WSTR nvarchar(50) 50
owner_user_scope DT_WSTR nvarchar(100) 100
owner_sms_mail_id DT_WSTR nvarchar(1020) 1020
owner_phone DT_WSTR nvarchar(1020) 1020
owner_employee_id DT_WSTR nvarchar(50) 50
owner_name DT_WSTR nvarchar(50) 50
owner_id DT_WSTR nvarchar(100) 100
owner_photo_url DT_WSTR nvarchar(500) 500
owner_is_vip_user DT_BOOL bit
owner_department DT_WSTR nvarchar(1020) 1020
owner_first_name DT_WSTR nvarchar(50) 50
owner_job_title DT_WSTR nvarchar(1020) 1020
template_inactive DT_BOOL bit
template_name DT_WSTR nvarchar(100) 100
template_id DT_WSTR nvarchar(100) 100
required_date_display_value DT_WSTR nvarchar(50) 50
required_date_value DT_WSTR nvarchar(100) 100
total_price_display_value DT_WSTR nvarchar(50) 50
total_price_currency_symbol DT_WSTR nvarchar(50) 50
total_price_value DT_R8 float
total_price_secondary_currency_display_value DT_R8 float
total_price_secondary_currency_currency_symbol DT_WSTR nvarchar(50) 50
total_price_secondary_currency_value DT_R8 float
custom_id DT_WSTR nvarchar(50) 50
sites DT_WSTR nvarchar(500) 500
requested_by_email_id DT_WSTR nvarchar(100) 100
requested_by_is_technician DT_BOOL bit
requested_by_sms_mail DT_WSTR nvarchar(1020) 1020
requested_by_mobile DT_WSTR nvarchar(50) 50
requested_by_last_name DT_WSTR nvarchar(50) 50
requested_by_user_scope DT_WSTR nvarchar(100) 100
requested_by_sms_mail_id DT_WSTR nvarchar(1020) 1020
requested_by_phone DT_WSTR nvarchar(1020) 1020
requested_by_employee_id DT_WSTR nvarchar(50) 50
requested_by_name DT_WSTR nvarchar(50) 50
requested_by_id DT_WSTR nvarchar(100) 100
requested_by_photo_url DT_WSTR nvarchar(500) 500
requested_by_is_vip_user DT_BOOL bit
requested_by_department DT_WSTR nvarchar(1020) 1020
requested_by_first_name DT_WSTR nvarchar(50) 50
requested_by_job_title DT_WSTR nvarchar(1020) 1020
vendor_name DT_WSTR nvarchar(50) 50
vendor_description DT_WSTR nvarchar(100) 100
vendor_currency_symbol DT_WSTR nvarchar(50) 50
vendor_currency_code DT_WSTR nvarchar(50) 50
vendor_currency_exchange_rate DT_WSTR nvarchar(50) 50
vendor_currency_name DT_WSTR nvarchar(50) 50
vendor_currency_id DT_WSTR nvarchar(100) 100
vendor_id DT_WSTR nvarchar(100) 100
name DT_WSTR nvarchar(50) 50
currency_symbol DT_WSTR nvarchar(50) 50
currency_code DT_WSTR nvarchar(50) 50
currency_exchange_rate DT_WSTR nvarchar(50) 50
currency_name DT_WSTR nvarchar(50) 50
currency_id DT_WSTR nvarchar(100) 100
created_date_display_value DT_WSTR nvarchar(50) 50
created_date DT_DBTIMESTAMP datetime
status_name DT_WSTR nvarchar(100) 100
status_id DT_WSTR nvarchar(100) 100
required_date DT_WSTR nvarchar(1020) 1020
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 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 or in API Destination SSIS Data Flow components to read or write data.

API Source

This Endpoint belongs to the PurchaseOrders table, therefore it is better to use it, instead of accessing the endpoint directly:

API Source - ManagedEngine ServiceDesk Plus (Zoho)
ManagedEngine (Zoho) ServiceDesk Plus Connector can be used to integrate ServiceDesk Plus data in your App / BI Tools. You can read/write Requests, Tasks, Comments, Worklogs and many other items.
ManagedEngine ServiceDesk Plus (Zoho)
PurchaseOrders
Required Parameters
PurchaseOrderId Fill-in the parameter...
Optional Parameters
MetaDetectionOrder Default
ContineOn404Error True
SSIS API Source - Read from table or endpoint

API Destination

This Endpoint belongs to the PurchaseOrders table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to get purchase order details:

API Destination - ManagedEngine ServiceDesk Plus (Zoho)
ManagedEngine (Zoho) ServiceDesk Plus Connector can be used to integrate ServiceDesk Plus data in your App / BI Tools. You can read/write Requests, Tasks, Comments, Worklogs and many other items.
ManagedEngine ServiceDesk Plus (Zoho)
PurchaseOrders
Lookup
Required Parameters
PurchaseOrderId Fill-in the parameter...
Optional Parameters
MetaDetectionOrder Default
ContineOn404Error True
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

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_order_details 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:

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_order_details endpoint belongs to PurchaseOrders table(s), and can therefore be used via those table(s).