PassThrough Requests for Sugar CRM
Sample PassThrough requeat for getting the list of possible values of currency field for create deal api and metaData.revenueLineItemId field for update deal Api in Sugar CRM.
List Currencies
Use the id field, in the response, as the currency in create deal api.
A cURL request could look like this:
curl --location 'https://api.getknit.dev/v1.0/passthrough' \
--header 'Authorization: Bearer <YOUR_API_KEY>' \
--header 'X-Knit-Integration-Id: <YOUR_INTEGRATION_ID>' \
--header 'accept: application/json' \
--header 'content-type: application/json' \
--data ''{
"method":"GET",
"path": "Currencies"
}'and the response could look like the following:
{
"success": true,
"data": {
"response": {
"body":"{\"next_offset\":-1,\"records\":[{\"id\":\"-99\",\"name\":\"US Dollars\",\"symbol\":\"$\",\"iso4217\":\"USD\",\"conversion_rate\":1,\"status\":\"Active\",\"deleted\":false,\"hide\":\"\<!--\",\"unhide\":\"--\>\",\"my_favorite\":false,\"_acl\":{\"fields\":{}},\"_module\":\"Currencies\"},{\"id\":\"8abd0cf4-2b2b-11f0-b8a8-8915a5f1d1ef\",\"name\":\"Euro\",\"symbol\":\"\€\",\"iso4217\":\"EUR\",\"conversion_rate\":0.9,\"status\":\"Active\",\"deleted\":false,\"date_entered\":\"2025-12-12T15:40:45+05:30\",\"date_modified\":\"2025-12-12T15:40:45+05:30\",\"created_by\":\"1\",\"sync_key\":\"\",\"hide\":\"\",\"unhide\":\"\",\"my_favorite\":false,\"_acl\":{\"fields\":{}},\"_module\":\"Currencies\"},{\"id\":\"1100a86c-5359-11ef-bcff-068962c7e2c7\",\"name\":\"Euro\",\"symbol\":\"\€\",\"iso4217\":\"EUR\",\"conversion_rate\":0.9,\"status\":\"Active\",\"deleted\":false,\"date_entered\":\"2025-03-13T00:02:26+05:30\",\"date_modified\":\"2025-03-13T00:02:26+05:30\",\"created_by\":\"1\",\"sync_key\":\"\",\"hide\":\"\",\"unhide\":\"\",\"my_favorite\":false,\"_acl\":{\"fields\":{}},\"_module\":\"Currencies\"}]}",
"headers": {
"Date": "Fri, 26 Sep 2025 10:34:35 GMT",
"Content-Type": "application/json",
"Connection": "keep-alive",
"Server": "Apache",
"X-XSS-Protection": "1; mode=block",
"X-Content-Type-Options": "nosniff",
"X-Frame-Options": "SAMEORIGIN",
"Strict-Transport-Security": "max-age=31536000; includeSubdomains",
"Cache-Control": "max-age=0, private",
"ETag": "187baaadc536fd44a3ac6859962c1af6",
"Vary": "Accept-Encoding",
"X-Application-Server": "salesdemous01-web-31",
"content-length": "957"
}
}
}
}List Revenue Line Items
Use the id field, in the response, as the metaData.revenueLineItemId in update deal api.
A cURL request could look like this:
curl --location 'https://api.getknit.dev/v1.0/passthrough' \
--header 'Authorization: Bearer <YOUR_API_KEY>' \
--header 'X-Knit-Integration-Id: <YOUR_INTEGRATION_ID>' \
--header 'accept: application/json' \
--header 'content-type: application/json' \
--data ''{
"method":"GET",
"path": "RevenueLineItems?filter=[{\"opportunity_id\":\"<DealID>\"}]"
}'and the response could look like the following:
{
"success": true,
"data": {
"response": {
"body": "{\"next_offset\":-1,\"records\":[{\"id\":\"42f3ac66-9ac5-11f0-9537-f56fb9796d66\",\"name\":\"VK Deal\",\"date_entered\":\"2025-09-26T16:10:47+05:30\",\"date_modified\":\"2025-09-26T16:10:47+05:30\",\"modified_user_id\":\"1\",\"modified_by_name\":\"Jen Smith\",\"modified_user_link\":{\"full_name\":\"Jen Smith\",\"id\":\"1\",\"_acl\":{\"fields\":{\"pwd_last_changed\":{\"write\":\"no\",\"create\":\"no\"},\"last_login\":{\"write\":\"no\",\"create\":\"no\"}},\"_hash\":\"6d408abe1708e7afd72eaecf780699c2\"}},\"created_by\":\"1\",\"created_by_name\":\"Jen Smith\",\"created_by_link\":{\"full_name\":\"Jen Smith\",\"id\":\"1\",\"_acl\":{\"fields\":{\"pwd_last_changed\":{\"write\":\"no\",\"create\":\"no\"},\"last_login\":{\"write\":\"no\",\"create\":\"no\"}},\"_hash\":\"6d408abe1708e7afd72eaecf780699c2\"}},\"description\":\"\",\"deleted\":false,\"product_template_id\":\"\",\"product_template_name\":\"\",\"rli_templates_link\":{\"name\":\"\",\"id\":\"\",\"_acl\":{\"fields\":[],\"_hash\":\"654d337e0e912edaa00dbb0fb3dc3c17\"}},\"lock_duration\":false,\"account_id\":\"312988b2-93c1-11f0-b965-e1a50711acce\",\"subtotal\":\"65000.000000\",\"total_amount\":\"65000.000000\",\"type_id\":\"\",\"quote_id\":\"\",\"manufacturer_id\":\"\",\"manufacturer_name\":\"\",\"manufacturers\":{\"name\":\"\",\"id\":\"\",\"_acl\":{\"fields\":[],\"_hash\":\"654d337e0e912edaa00dbb0fb3dc3c17\"}},\"category_id\":\"\",\"category_name\":\"\",\"rli_categories_link\":{\"name\":\"\",\"id\":\"\",\"_acl\":{\"fields\":[],\"_hash\":\"654d337e0e912edaa00dbb0fb3dc3c17\"}},\"mft_part_num\":\"\",\"cost_price\":\"\",\"discount_price\":\"65000.000000\",\"discount_amount\":\"0.000000\",\"discount_select\":true,\"discount_rate_percent\":0,\"discount_amount_usdollar\":0,\"discount_amount_signed\":\"0.000000\",\"deal_calc\":\"0.000000\",\"deal_calc_usdollar\":\"0.000000\",\"cost_usdollar\":\"\",\"discount_usdollar\":\"65000.000000\",\"list_usdollar\":\"\",\"status\":\"\",\"book_value_usdollar\":\"\",\"generate_purchase\":\"Yes\",\"purchasedlineitem_id\":\"\",\"purchasedlineitem_name\":\"\",\"purchasedlineitem\":{\"name\":\"\",\"id\":\"\",\"_acl\":{\"fields\":[],\"_hash\":\"654d337e0e912edaa00dbb0fb3dc3c17\"}},\"best_case\":\"65000.000000\",\"likely_case\":\"65000.000000\",\"worst_case\":\"65000.000000\",\"date_closed\":\"2025-09-25\",\"date_closed_timestamp\":1758758400,\"next_step\":\"\",\"commit_stage\":\"exclude\",\"sales_stage\":\"Id. Decision Makers\",\"probability\":40,\"lead_source\":\"\",\"campaign_id\":\"\",\"campaign_name\":\"\",\"campaign_revenuelineitems\":{\"name\":\"\",\"id\":\"\",\"_acl\":{\"fields\":{\"peoplewhoopened\":{\"create\":\"no\",\"write\":\"no\",\"license\":\"no\"},\"peoplewhoclicked\":{\"create\":\"no\",\"write\":\"no\",\"license\":\"no\"},\"bounced\":{\"create\":\"no\",\"write\":\"no\",\"license\":\"no\"},\"notreported\":{\"create\":\"no\",\"write\":\"no\",\"license\":\"no\"},\"delivered\":{\"create\":\"no\",\"write\":\"no\",\"license\":\"no\"},\"social\":{\"create\":\"no\",\"write\":\"no\",\"license\":\"no\"},\"sent\":{\"create\":\"no\",\"write\":\"no\",\"license\":\"no\"},\"postdate\":{\"create\":\"no\",\"write\":\"no\",\"license\":\"no\"},\"forwards\":{\"create\":\"no\",\"write\":\"no\",\"license\":\"no\"},\"unopened\":{\"create\":\"no\",\"write\":\"no\",\"license\":\"no\"},\"unsubscribed\":{\"create\":\"no\",\"write\":\"no\",\"license\":\"no\"},\"totalopens\":{\"create\":\"no\",\"write\":\"no\",\"license\":\"no\"},\"totalclicks\":{\"create\":\"no\",\"write\":\"no\",\"license\":\"no\"}},\"_hash\":\"ea0dd9a7291770652f6587c8f1f4e1f9\"}},\"forecasted_likely\":\"0.000000\",\"quote_name\":\"\",\"quotes\":{\"name\":\"\",\"id\":\"\",\"_acl\":{\"fields\":[],\"_hash\":\"654d337e0e912edaa00dbb0fb3dc3c17\"}},\"opportunity_id\":\"421fba78-9ac5-11f0-a236-2fd36ee20bd3\",\"opportunity_name\":\"VK Deal\",\"opportunities\":{\"name\":\"VK Deal\",\"id\":\"421fba78-9ac5-11f0-a236-2fd36ee20bd3\",\"_acl\":{\"fields\":[],\"_hash\":\"654d337e0e912edaa00dbb0fb3dc3c17\"}},\"product_type\":\"\",\"type_name\":\"\",\"revenuelineitem_types_link\":{\"name\":\"\",\"id\":\"\",\"_acl\":{\"fields\":[],\"_hash\":\"654d337e0e912edaa00dbb0fb3dc3c17\"}},\"account_name\":\"Test ABC Account\",\"account_link\":{\"name\":\"Test ABC Account\",\"id\":\"312988b2-93c1-11f0-b965-e1a50711acce\",\"_acl\":{\"fields\":[],\"_hash\":\"654d337e0e912edaa00dbb0fb3dc3c17\"}},\"add_on_to_id\":\"\",\"add_on_to_name\":\"\",\"pli_addons_link\":{\"name\":\"\",\"id\":\"\",\"_acl\":{\"fields\":[],\"_hash\":\"654d337e0e912edaa00dbb0fb3dc3c17\"}},\"renewal_rli_id\":\"\",\"renewal_rli_name\":\"\",\"renewal_rli_link\":{\"name\":\"\",\"id\":\"\",\"_acl\":{\"fields\":[],\"_hash\":\"654d337e0e912edaa00dbb0fb3dc3c17\"}},\"following\":false,\"my_favorite\":false,\"tag\":[],\"locked_fields\":[],\"sync_key\":\"\",\"assigned_user_id\":\"\",\"assigned_user_name\":\"\",\"assigned_user_link\":{\"full_name\":\"\",\"id\":\"\",\"_acl\":{\"fields\":[],\"_hash\":\"654d337e0e912edaa00dbb0fb3dc3c17\"}},\"team_count\":\"\",\"team_count_link\":{\"team_count\":\"\",\"id\":\"1\",\"_acl\":{\"fields\":[],\"_hash\":\"654d337e0e912edaa00dbb0fb3dc3c17\"}},\"team_name\":[{\"id\":\"1\",\"name\":\"Global\",\"name_2\":\"\",\"primary\":true,\"selected\":false}],\"asset_number\":\"\",\"book_value\":\"\",\"book_value_date\":\"\",\"date_purchased\":\"\",\"date_support_expires\":\"\",\"date_support_starts\":\"\",\"list_price\":\"\",\"pricing_factor\":null,\"pricing_formula\":\"\",\"quantity\":1,\"serial_number\":\"\",\"renewable\":false,\"service\":false,\"service_duration_value\":null,\"service_duration_unit\":\"\",\"catalog_service_duration_value\":null,\"catalog_service_duration_unit\":\"\",\"service_duration_multiplier\":1,\"service_end_date\":\"\",\"service_start_date\":\"\",\"support_contact\":\"\",\"support_description\":\"\",\"support_name\":\"\",\"support_term\":\"\",\"tax_class\":\"Taxable\",\"vendor_part_num\":\"\",\"website\":\"\",\"weight\":null,\"renewal\":false,\"currency_id\":\"-99\",\"base_rate\":\"1.000000\",\"currency_name\":\"\",\"currencies\":{\"name\":\"\",\"id\":\"-99\",\"_acl\":{\"fields\":[],\"_hash\":\"654d337e0e912edaa00dbb0fb3dc3c17\"},\"symbol\":\"\"},\"currency_symbol\":\"\",\"denorm_account_name\":\"Test ABC Account\",\"_acl\":{\"fields\":{}},\"_module\":\"RevenueLineItems\"}]}",
"headers": {
"Date": "Fri, 26 Sep 2025 10:41:05 GMT",
"Content-Type": "application/json",
"Connection": "keep-alive",
"Server": "Apache",
"X-XSS-Protection": "1; mode=block",
"X-Content-Type-Options": "nosniff",
"X-Frame-Options": "SAMEORIGIN",
"Strict-Transport-Security": "max-age=31536000; includeSubdomains",
"Cache-Control": "max-age=0, private",
"ETag": "3f6383c5794608de7644c922dcc4ae24",
"Vary": "Accept-Encoding",
"X-Application-Server": "salesdemous01-web-22",
"content-length": "5369"
}
}
}
}Updated about 6 hours ago