{"id":3224,"date":"2019-02-17T04:47:04","date_gmt":"2019-02-17T04:47:04","guid":{"rendered":"https:\/\/answers.gurussolutions.com\/answers\/comment-configurer-les-filtres-dintegration-avances-pour-netsuite-suiteprojects-pro\/"},"modified":"2026-07-28T18:25:36","modified_gmt":"2026-07-28T18:25:36","slug":"comment-configurer-les-filtres-dintegration-avances-pour-netsuite-suiteprojects-pro","status":"publish","type":"qa_entry","link":"https:\/\/answers.gurussolutions.com\/fr\/answers\/comment-configurer-les-filtres-dintegration-avances-pour-netsuite-suiteprojects-pro\/","title":{"rendered":"Comment configurer les filtres d&rsquo;int\u00e9gration avanc\u00e9s pour NetSuite SuiteProjects Pro"},"content":{"rendered":"","protected":false},"template":"","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","ga_subtitle":"Apprenez \u00e0 d\u00e9finir des filtres de champs personnalis\u00e9s pour une synchronisation transparente des donn\u00e9es entre NetSuite et NetSuite SuiteProjects Pro \u00e0 l\u2019aide d\u2019une syntaxe de mappage avanc\u00e9e.","ga_short_answer":"Pour filtrer les donn\u00e9es entre NetSuite et NetSuite SuiteProjects Pro en fonction d\u2019un champ personnalis\u00e9, d\u00e9clarez ce champ \u00e0 l\u2019aide de NS_FIELDS et NS_CUSTOM_FIELDS dans votre mappage d\u2019int\u00e9gration. D\u00e9finissez ensuite la condition de filtrage dans un bloc FILTER <<END ... END, en pr\u00e9cisant l'identifiant interne du champ personnalis\u00e9 et la valeur souhait\u00e9e, telle que \u00ab Approuv\u00e9 \u00bb.","ga_scenario":"Les entreprises ont souvent besoin d\u2019un contr\u00f4le pr\u00e9cis sur la synchronisation des donn\u00e9es entre NetSuite et NetSuite SuiteProjects Pro. Un sc\u00e9nario courant consiste \u00e0 filtrer les enregistrements en fonction de la valeur d\u2019un champ personnalis\u00e9, tel que \u00ab custentity_gs_projectapproval \u00bb, afin de garantir que seules certaines donn\u00e9es, comme les projets \u00ab Approuv\u00e9s \u00bb, soient transf\u00e9r\u00e9es. Cela n\u00e9cessite de configurer un filtre d\u2019int\u00e9gration avanc\u00e9 au sein du mappage.","ga_solution":"Pour mettre en place un filtre d\u2019int\u00e9gration avanc\u00e9 entre NetSuite et NetSuite SuiteProjects Pro bas\u00e9 sur un champ personnalis\u00e9, veuillez suivre les \u00e9tapes suivantes :\n1. Identifiez l\u2019identifiant interne du champ personnalis\u00e9 \u00e0 utiliser pour le filtrage. Dans cet exemple, le champ d\u2019entit\u00e9 personnalis\u00e9 est \u00ab custentity_gs_projectapproval \u00bb.\n2. Dans le mappage d\u2019int\u00e9gration, d\u00e9clarez le champ personnalis\u00e9 \u00e0 l\u2019aide \u00e0 la fois de NS_FIELDS et de NS_CUSTOM_FIELDS. Bien que NS_FIELDS et NS_CUSTOM_FIELDS soient souvent utilis\u00e9s dans des contextes de mappage avanc\u00e9s, leur d\u00e9claration explicite n\u2019est pas n\u00e9cessairement requise pour tous les workflows d\u2019importation personnalis\u00e9s. Pour les champs NetSuite pr\u00eats \u00e0 l\u2019emploi, NS_CUSTOM_FIELDS n\u2019est pas n\u00e9cessaire.\n3. D\u00e9finissez la condition de filtrage \u00e0 l\u2019aide du bloc FILTER <<END ... END. Bien que NetSuite propose d\u00e9sormais un g\u00e9n\u00e9rateur de filtres pour simplifier la cr\u00e9ation de filtres, cette syntaxe explicite reste une m\u00e9thode valable pour les besoins de filtrage avanc\u00e9s.La syntaxe suivante montre comment filtrer les enregistrements pour lesquels custentity_gs_projectapproval a la valeur \u00ab Approved \u00bb :\n```\nNS_FIELDS custentity_gs_projectapprovalNS_CUSTOM_FIELDS custentity_gs_projectapprovalFILTER <<END(custentity_gs_projectapproval = 'Approved ')END\n```\n. Cette configuration garantit que seuls les enregistrements r\u00e9pondant au statut d\u2019approbation sp\u00e9cifi\u00e9 sont synchronis\u00e9s entre NetSuite et NetSuite SuiteProjects Pro.","ga_source_author":"Matthew Jay","ga_source_author_email":"","ga_date_original":"2019-02-16T20:47:04-08:00","ga_date_verified":"2026-07-05","ga_source_subject":"How do you use integration filters between NetSuite and OpenAir?","ga_ans_id":"ANS-1485","ga_publish_decision":"publish_with_edits","ga_staleness_risk":"high","ga_review_priority":"verify_soon","ga_tier2_verdict":"partially_outdated","ga_tier2_concerns":"The product 'OpenAir' has been rebranded to 'NetSuite SuiteProjects Pro' as of late 2024\/early 2025.; While NS_FIELDS and NS_CUSTOM_FIELDS are still used in some advanced mapping contexts, for 'custom import workflows' they are explicitly stated as not required and will be ignored.; NetSuite now offers a 'filter builder' that simplifies filter creation, removing the explicit need for field declarations and opening\/closing filter block statements like 'FILTER <<END ... END', suggesting this syntax, while potentially still functional, may not be the primary or most current method for all filtering needs.","ga_final_category":"Web Services & Integrations","footnotes":""},"ga_category":[102,28,102],"ga_audience":[30],"ga_difficulty":[94],"class_list":["post-3224","qa_entry","type-qa_entry","status-publish","hentry","ga_category-services-web-et-integrations","ga_category-web-services-integrations","ga_audience-it-integration-team","ga_difficulty-avance"],"taxonomy_info":{"ga_category":[{"value":102,"label":"Services Web et int\u00e9grations"},{"value":28,"label":"Web Services & Integrations"},{"value":102,"label":"Services Web et int\u00e9grations"}],"ga_audience":[{"value":30,"label":"IT\/integration team"}],"ga_difficulty":[{"value":94,"label":"Avanc\u00e9"}]},"featured_image_src_large":[],"author_info":[],"comment_info":"","_links":{"self":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3224","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry"}],"about":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/types\/qa_entry"}],"version-history":[{"count":1,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3224\/revisions"}],"predecessor-version":[{"id":5144,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/qa_entry\/3224\/revisions\/5144"}],"wp:attachment":[{"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/media?parent=3224"}],"wp:term":[{"taxonomy":"ga_category","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_category?post=3224"},{"taxonomy":"ga_audience","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_audience?post=3224"},{"taxonomy":"ga_difficulty","embeddable":true,"href":"https:\/\/answers.gurussolutions.com\/fr\/wp-json\/wp\/v2\/ga_difficulty?post=3224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}