Description
Netsuite is a unified business management suite, encompassing ERP/Financials, CRM, and e-commerce for more than 31,000 customers.
This integration implements the SuiteTalk REST Web Services and uses REST API to fetch the customer's data. For a complete overview, refer to SuiteTalk REST Web Services
Note that this API is still in beta version.
Features
| Feature Name | Supported | Comment |
|---|---|---|
| Full Import | Yes | |
| Incremental Import | Yes | |
| Re-Import | Yes | |
| Start Date Selection | Yes | |
| Import Empty Tables | No | |
| Custom Data | Yes/No | |
| Dynamic Column Selection | No |
Overview
datetime format
Only these two format %m/%d/%Y, %Y-%m-%d are accepted for all the integration. Follow these steps to change the DateTime format in NetSuite.
Performance Consideration
The connector is restricted by Netsuite Concurrency Limit per Integration
Permissions
All the permissions in Transactions, Reports, Lists, and Setup are required in order to import the data successfully.
Recommendations
There are almost ~200 streams (depending on Role to Role) so it would be better to import them in chunks.
Connector
This connector was developed following the standards of Airbyte.
Authentication
OAuth 1.0 is used for authentication. and the following keys are required
- realm
- consumer_key
- consumer_secret
- token_key
- token_secret
Follow Step 2: Setup NetSuite account to get all these keys.
Schema
This source is based on the SuiteTalk REST Web Services.
Supported Streams
Streams are generated based on ROLE and USER access to them as well as Account settings.
Following ~200 (you might not see all of them based on Role and permission) streams are working as expected.
List of streams
- customrecord_ep_company_information
- customrecord_mapper_values
- timebill
- inventoryitem
- customlist_12194_processing_result
- customrecord_subnav_settings
- customrecord_transaction_nature
- customlist_ns_actionitemtype
- customer
- customrecord_no_standard_tax_codes
- customlist_2663_process_status
- customrecord_tax_report_map_details
- customrecord_mapper_keyvalue
- customrecord_intrastat_region
- customlist_zreports_ba_codes
- customrecord_str_region_of_origin
- customrecord_ns_uatitem
- customlist_2663_output_file_encoding
- contact
- invoice
- customrecord_nsapm_setup_parent
- customlist_sii_list_type
- customrecord_notc
- customlist_2663_entity_bank_type
- customrecord_vatonline_detail
- customlist_2663_day_of_week
- customrecord_str_commodity_code
- customersubsidiaryrelationship
- customlist_ns_cx_defectstatus
- customrecord_no_std_tax_keyvalue
- customrecord_taf_report_threshold
- customlist_2663_schedule_type
- customrecord_4digit_account_values
- salesorder
- customlist_2663_direct_debit_type
- customlist_dt_tile_summarytype
- customrecord_mapper_filter
- customlist_csr_relperiodto
- customlist_deferred_tax
- customlist_csr_net_amount_calc_methods
- customlist_taf_task_status
- customrecord_ns_cutoverunit
- message
- customrecord_tax_form
- customrecord_csr_country
- customrecord_taf_job
- customlist_ep_payment_priority
- customrecord_kb_storage
- customlist_dt_tile_type
- customrecord_regime_code
- customrecord_income_statement_1167
- customlist_csr_filter_block_type
- vendorbill
- customrecord_trantypelist
- customlist_csr_column_2_definition
- customlist_gl_zreport_types
- customrecord_tax_report_map
- customrecord_4599_sys_note
- customrecord_2663_execution_log
- task
- customlist_csr_cond_operators
- customrecord_2663_bill_eft_details
- customlist_str_transport_mode
- customlist_csr_value_type
- customrecord_encryption_details
- customlist_ns_ai_priority
- customrecord_template_content
- customlist_taf_job_status
- customrecord_bf_se_next_transaction_id
- customrecord_ecsl_audit_trail_hdr
- customrecord_taf_rep_config
- customrecord_stc_config_fields
- customlist_ns_cutovermethods
- customrecord_4599
- customrecord_2663_dummy_list
- customrecord_country
- customrecord_alf_tx_printing_history
- itemfulfillment
- customlist_2663_payment_type
- customrecord_alf_method_of_payment
- customlist_atlas_appr_by_creator
- customrecord_wd_naw_workflow_excep
- customlist_2663_batch_status
- employee
- customlist_str_delivery_terms
- customrecord_no_4digit_mapping
- customrecord_taf_report_task
- subscriptionline
- customrecord_stc_config_values
- customlist_regime_code_of_supply
- customrecord_report_preferences_mapping
- customrecord_lsa
- customlist_2663_acct_type
- customrecord_supplementary_unit
- customlist_ns_cx_deployedto
- customlist_2663_bank_fee_code
- customrecord_sii_reg_error_codes
- customlist_csr_report_copy_task_status
- customlist_2663_week_of_month
- customlist_dt_tile_comparetype
- customlist_csr_export_type
- customrecord_str_supplementary_units
- customrecord_itr_system_parameter
- customrecord_alf_cust_inv_translations
- customlist_tax_exemption_code
- customrecord_income_statement_1175
- customlist_code_of_supply
- customrecord_moss_provisioning_status
- customlist_alf_lock_invoice_mode
- customrecord_atlas_mfg_std_adjust_reason
- customrecord_ecsl_audit_trail_dtl
- customrecord_bf_se_debug_mode_switch
- customrecord_mode_of_transport
- customlist_operation_type
- customlist_alf_printout_type
- customrecord_taf_setupconfig_value
- customlist_dt_tile_transflds
- customrecord_bf_audittrail
- phonecall
- customrecord_com_defect
- customrecord_no_2digit_mapping
- customrecord_taf_configuration
- customrecord_ns_actionitem
- vendorsubsidiaryrelationship
- customlist_atlas_link
- customrecord_no_in_mapper_1323_keyvalue
- customrecord_gl_setup_component
- journalentry
- customlist_11664_payment_mode
- customrecord_statutory_coa
- customrecord_bf_se_customer_id
- customrecord_ns_cutovermanagementprefere
- customrecord_2digit_account_values
- customlist_csr_relperiodfrom
- customrecord_10782_cntryfmts_by_edition
- customrecord_tax_return_setup_item
- customlist_8299_license_cache_status
- vendor
- customrecord_2663_file_admin
- customlist_2663_reference_amended_type
- customlist_vb_memo_list
- customrecord_vatonline_submittedperiod
- calendarevent
- customrecord_mapper_category
- customrecord_str_notc
- customlist_2663_batch_priority
- customrecord_stc_ppd_queue
- customrecord_no_income_mapper_keyvalue
- customrecord_engine_sequence
- customlist_ns_cx_deploymentstatus
- customlist_2663_approval_type
- customlist_dt_translatable_flds
- customlist_alf_mop_types
- customlist_2663_billing_type
- customrecord_no_in_mapper_1167_keyvalue
- customlistgl_list_german_region
- customrecord_ns_configurationitem
- customrecord_emea_get_country
- customlist_nature_of_transaction_code
- customrecord_ns_project
- noninventorysaleitem
- customlist_csr_creditdebit
- customlist_ns_cfi_types
- assemblyitem
- customrecord_tax_cache_detail
- customrecord_pt_taxonomy_reference
- customrecord_tax_template
- customrecord_pt_mr_task_summary
- customlist_ns_ai_status
- customlist_2663_ep_process
- customrecord_bf_se_excluded_accounts
- customlist_2663_bank_acct_type
- customrecord_no_in_mapper_1175_keyvalue
- customrecord_tax_field
- contactrole
- customlist_sub_tax_code_trans_type
- customrecord_statistical_procedure
- subsidiary
- customlist_dt_wrapping
- customlist_sii_registration_status
- cashsale
- customlist_2663_approval_level
- customlist_dt_tile_alertops
- customlist_8299_cat_type
- customrecord_atlas_de_ff_mm_pdflabels
- customlist_atlas_cust_type
- customlist_bf_api_types
- customrecord_ns_processtaxonomy
- customrecord_tax_report_map_option
- customrecord_norway_mapper_keyvalue
- customlist_type_of_goods
- customrecord_notc_default
- customrecord_stc_nexus_configuration
- customrecord_template_attachment
- customlist_2663_schedule_event_type
- customlist_gl_list_componentstatus
- customrecord_no_sub_tax_codes
- customrecord_taf_setupconfig
- customrecord_income_statement_1323
- subscriptionplan
- emailtemplate
- customlist_csr_math_operations
- customrecord_str_statistical_procedure
- contactcategory
- customlist_psg_emea_l10n_status
- creditmemo
- customlist_delivery_terms
- customrecord_sii_list_val
- customlist_ns_uatstatus
- purchaseorder
- customlist_alf_cfg_text_colors
- customrecord_kb_worker
- customlist_2663_recurrence
- customrecord_tax_cache
- customrecord_taf_search_task
- customrecord_tax_field_notation