@cfxlabsinc/b2b-services
    Preparing search index...

    Class AiPriseBusinessProfileService

    Shadow-copy service for AiPrise business (KYB) profiles. The backoffice-api webhook consumer calls refresh on every AiPrise business-profile event; readers use get / getByAipriseId / search instead of calling AiPrise.

    Index
    constructor
    instance
    get getByAipriseId refresh search
    instance: (...args: []) => AiPriseBusinessProfileService = ...

    The process default: built from each dependency's own instance().

    • Fetches the full profile from AiPrise and upserts the shadow row. The upsert is monotonic on the payload's updated_at: a snapshot older than the stored one never overwrites data / the extracted columns (out-of-order webhook retries), but the successful fetch still bumps syncedAt and clears deletedAt — a live fetch proves the profile exists.

      Parameters

      • args: { aipriseId: string }

      Returns Promise<
          | {
              ok: true;
              value: Omit<
                  SelectAiPriseBusinessProfile,
                  | "id"
                  | "externalId"
                  | "emailAddresses"
                  | "phoneNumbers"
                  | "data"
                  | "deletedAt",
              > & {
                  data: {
                      additional_information?: {
                          additional_info_data?: (...)
                          | (...)
                          | (...);
                          additional_info_type?:
                              | (...)
                              | (...)
                              | (...)
                              | (...)
                              | (...)
                              | (...)
                              | (...)
                              | (...)
                              | (...)
                              | (...)
                              | (...)
                              | (...)
                              | (...)
                              | (...)
                              | (...)
                              | (...)
                              | (...)
                              | (...)
                              | (...)
                              | (...)
                              | (...)
                              | (...)
                              | (...)
                              | (...)
                              | (...)
                              | (...)
                              | (...)
                              | (...)
                              | (...);
                      }[];
                      addresses?: {
                          address_city?: (...)
                          | (...);
                          address_country?: (...) | (...);
                          address_state?: (...) | (...);
                          address_street_1?: (...) | (...);
                          address_street_2?: (...) | (...);
                          address_zip_code?: (...) | (...);
                      }[];
                      alternate_name?: string;
                      business_entity_id?: string;
                      callback_url?: string;
                      client_reference_data?: Record<string, never>;
                      client_reference_id?: string;
                      country_code?: string;
                      email_addresses?: string[];
                      events_callback_url?: string;
                      formation_date?: string;
                      name?: string;
                      phone_numbers?: string[];
                      state_code?: string;
                      tags?: string[];
                      tax_identification_number?: string;
                      website?: string;
                  } & {
                      aml_info?: {
                          aml_hit_summary?: { [key: ...]: ... };
                          entity_hits?: (...)[];
                          num_hits?: number;
                          result?: "APPROVED" | "DECLINED" | "REVIEW" | "UNKNOWN" | null;
                          search_criteria?: {
                              birth_year?: ...;
                              exact_match?: ...;
                              fuzziness_score?: ...;
                              search_term?: ...;
                          };
                          section_id?: string;
                          status?: | "NOT_STARTED"
                          | "RUNNING"
                          | "PENDING"
                          | "FAILED"
                          | "COMPLETED"
                          | "SUBMITTED"
                          | null;
                          status_reasons?: (...)[];
                          warnings?: (...)[];
                      };
                      aml_monitoring_info?: {
                          added_entity_hits?: (...)
                          | (...)
                          | (...);
                          created_at?: (...) | (...) | (...);
                          removed_entity_hits?: (...) | (...) | (...);
                          updated_entity_hits?: (...) | (...) | (...);
                      }[];
                      business_info?: {
                          additional_fields?: { [key: ...]: ... };
                          addresses?: (...)[];
                          business_id?: string;
                          business_scope?: {
                              business_activities?: ...;
                              business_description?: ...;
                          };
                          country_code?: string;
                          emails?: (...)[];
                          entity_type?: string;
                          name?: string;
                          phone_numbers?: (...)[];
                          result?:
                              | "APPROVED"
                              | "DECLINED"
                              | "REVIEW"
                              | "UNKNOWN"
                              | "FOUND"
                              | "NOT_FOUND";
                          section_id?: string;
                          status?: | "NOT_STARTED"
                          | "RUNNING"
                          | "PENDING"
                          | "FAILED"
                          | "COMPLETED"
                          | "SUBMITTED"
                          | null;
                          status_reasons?: (...)[];
                          tax_id?: string;
                          warnings?: (...)[];
                          website?: string;
                      };
                      business_profile_id?: string;
                      business_profile_result?: | "APPROVED"
                      | "DECLINED"
                      | "REVIEW"
                      | "UNKNOWN"
                      | "FOUND"
                      | "NOT_FOUND";
                      created_at?: number;
                      documents?: {
                          document_date?: (...)
                          | (...);
                          document_price?: (...) | (...) | (...);
                          document_published_date?: (...) | (...) | (...);
                          document_source_authority?: (...) | (...) | (...);
                          document_source_authority_code?: (...) | (...) | (...);
                          file_blob?: (...) | (...);
                          file_created_at?: (...) | (...) | (...);
                          file_format_type?: (...) | (...) | (...);
                          file_name?: (...) | (...);
                          file_s3_url?: (...) | (...);
                          file_source?: (...) | (...) | (...);
                          file_type?: (...) | (...) | (...);
                          file_uuid?: (...) | (...);
                          is_purchased?: (...) | (...) | (...) | (...);
                          order_status?: (...) | (...) | (...);
                          verification_sessions?: (...) | (...) | (...);
                      }[];
                      events?: {
                          date?: (...)
                          | (...)
                          | (...);
                          event_type?: (...) | (...) | (...);
                          metadata?: (...) | (...) | (...);
                      }[];
                      fraud_insights?: {
                          device_insights?: {
                              bot_status?: ...;
                              bot_type?: ...;
                              browser_full_version?: ...;
                              browser_major_version?: ...;
                              browser_name?: ...;
                              device?: ...;
                              incognito?: ...;
                              os?: ...;
                              os_version?: ...;
                              privacy_settings?: ...;
                              result?: ...;
                              section_id?: ...;
                              status?: ...;
                              status_reasons?: ...;
                              user_agent?: ...;
                              warnings?: ...;
                          };
                          email_insights?: (...)[];
                          geolocation_insights?: {
                              accuracy?: ...;
                              altitude?: ...;
                              altitude_accuracy?: ...;
                              heading?: ...;
                              latitude?: ...;
                              longitude?: ...;
                              result?: ...;
                              section_id?: ...;
                              speed?: ...;
                              status?: ...;
                              status_reasons?: ...;
                              warnings?: ...;
                          };
                          ip_insights?: {
                              abuse_velocity?: ...;
                              active_tor?: ...;
                              active_vpn?: ...;
                              autonomous_system_number?: ...;
                              bot_status?: ...;
                              connection_type?: ...;
                              host?: ...;
                              internet_service_provider?: ...;
                              ip_address?: ...;
                              is_crawler?: ...;
                              location?: ...;
                              organization?: ...;
                              proxy?: ...;
                              recent_abuse?: ...;
                              result?: ...;
                              section_id?: ...;
                              status?: ...;
                              status_reasons?: ...;
                              tor?: ...;
                              unique_hash?: ...;
                              vpn?: ...;
                              warnings?: ...;
                          };
                          phone_insights?: (...)[];
                          related_session_insights?: {
                              related_sessions?: ...;
                              result?: ...;
                              section_id?: ...;
                              status?: ...;
                              status_reasons?: ...;
                              warnings?: ...;
                          };
                          result?: | "APPROVED"
                          | "DECLINED"
                          | "REVIEW"
                          | "UNKNOWN"
                          | "FOUND"
                          | "NOT_FOUND";
                          section_id?: string;
                          status?: | "NOT_STARTED"
                          | "RUNNING"
                          | "PENDING"
                          | "FAILED"
                          | "COMPLETED"
                          | "SUBMITTED"
                          | null;
                          status_reasons?: (...)[];
                          warnings?: (...)[];
                      };
                      lookup_info?: {
                          data?: (...)
                          | (...)
                          | (...);
                          database_name?: (...) | (...) | (...);
                          result?: (...) | (...) | (...) | (...) | (...) | (...);
                          section_id?: (...) | (...);
                          status?: (...) | (...) | (...) | (...) | (...) | (...) | (...) | (...);
                          status_reasons?: (...) | (...) | (...);
                          title?: (...) | (...) | (...);
                          warnings?: (...) | (...) | (...);
                      }[];
                      online_presence_info?: {
                          address?: {
                              additional_info?: ...;
                              full_address?: ...;
                              parsed_address?: ...;
                              source?: ...;
                          };
                          business_entity_id?: string;
                          company_data?: Record<(...), (...)>;
                          formation_date?: string;
                          name?: string;
                          result?:
                              | "APPROVED"
                              | "DECLINED"
                              | "REVIEW"
                              | "UNKNOWN"
                              | "FOUND"
                              | "NOT_FOUND";
                          section_id?: string;
                          status?: | "NOT_STARTED"
                          | "RUNNING"
                          | "PENDING"
                          | "FAILED"
                          | "COMPLETED"
                          | "SUBMITTED"
                          | null;
                          status_reasons?: (...)[];
                          tax_identification_number?: string;
                          ubos?: (...)[];
                          warnings?: (...)[];
                          website?: string;
                      };
                      questions_response?: {
                          [key: string]: { [key: string]: (...)
                          | (...)
                          | (...) };
                      };
                      registration_info?: {
                          formation_date?: string
                          | null;
                          normalised_status?: string | null;
                          registration_records?: (...)[];
                          status?: string | null;
                      };
                      related_companies?: (
                          | (...) & (...)
                          | {
                              additional_fields?: ...;
                              business_profile?: ...;
                              company_reference_id?: ...;
                              other_relationship_data?: ...;
                              ownership_percent?: ...;
                              relationship_type?: ...;
                              roles?: ...;
                              shares_allocated?: ...;
                          }
                      )[];
                      related_people?: (
                          | (...) & (...)
                          | {
                              additional_fields?: ...;
                              other_relationship_data?: ...;
                              ownership_percent?: ...;
                              person_reference_id?: ...;
                              roles?: ...;
                              shares_allocated?: ...;
                              user_profile?: ...;
                          }
                      )[];
                      risk_info?: | {
                          decisioning?: {
                              result?: ...;
                              rules_evaluated?: ...;
                              section_id?: ...;
                          };
                          scoring?: {
                              risk_level?: ...;
                              rules_evaluated?: ...;
                              score?: ...;
                              section_id?: ...;
                          };
                      }
                      | null;
                      updated_at?: number;
                      verification_session_ids?: string[];
                      website_info?: {
                          adverse_media?: (...)[];
                          average_review?: string | null;
                          backlinks?: (...)[];
                          critically_concerning_issues?: (...)[];
                          description?: string | null;
                          domain_creation_date?: string | null;
                          domain_expiration_date?: string | null;
                          domain_info?: {
                              dns_address_status?: ...;
                              DNS_records?: ...;
                              domain_age?: ...;
                              domain_history?: ...;
                              expiration_date?: ...;
                              has_robots_txt?: ...;
                              hosting_provider?: ...;
                              hosting_provider_category?: ...;
                              inbound_linking_domains?: ...;
                              is_known_free_email_host?: ...;
                              is_known_hosting_provider_domain?: ...;
                              is_known_marketplace_domain?: ...;
                              is_known_social_media_domain?: ...;
                              is_known_top_domain?: ...;
                              is_non_business?: ...;
                              is_parked?: ...;
                              is_registered?: ...;
                              is_resolvable?: ...;
                              is_ssl_valid?: ...;
                              is_webserver_responsive?: ...;
                              last_update_date?: ...;
                              name?: ...;
                              ns_status?: ...;
                              registrar?: ...;
                              registrar_country?: ...;
                              registration_date?: ...;
                              supports_apex_and_www?: ...;
                              tech_stack_used?: ...;
                              whois_privacy_mode?: ...;
                          };
                          estimated_employee_count_range?: string
                          | null;
                          financial_info?: {
                              debtToEquity?: ...;
                              funding_amount?: ...;
                              marketCapitalization?: ...;
                              net_income?: ...;
                              revenue_amount?: ...;
                          };
                          formation_type?: string;
                          founded_year?: string
                          | null;
                          industry_inconsistencies?: (...)[];
                          industry_info?: {
                              additional_mcc_codes?: ...;
                              additional_naics_codes?: ...;
                              additional_risky_industry_flag?: ...;
                              additional_sic_codes?: ...;
                              high_risk_industry_contexts?: ...;
                              primary_industry?: ...;
                              primary_mcc?: ...;
                              primary_naics?: ...;
                              primary_risky_industry_flag?: ...;
                              primary_sic?: ...;
                              prohibited_industry_contexts?: ...;
                              tags?: ...;
                          };
                          interactions_of_interest?: (...)[];
                          is_public?: boolean | null;
                          name?: string;
                          network_intelligence?: { associated_networks?: ... };
                          result?:
                              | "APPROVED"
                              | "DECLINED"
                              | "REVIEW"
                              | "UNKNOWN"
                              | "FOUND"
                              | "NOT_FOUND";
                          risk_factors?: (...)[];
                          risk_indicators?: (...)[];
                          section_id?: string;
                          site_status?: string | null;
                          social_media_insights?: {
                              facebook?: ...;
                              instagram?: ...;
                              linkedin?: ...;
                          };
                          social_media_profiles?: (...)[];
                          social_media_profiles_referring_to_different_business?: (...)[];
                          status?:
                              | "NOT_STARTED"
                              | "RUNNING"
                              | "PENDING"
                              | "FAILED"
                              | "COMPLETED"
                              | "SUBMITTED"
                              | null;
                          status_reasons?: (...)[];
                          title?: string | null;
                          total_backlinks?: number | null;
                          traffic_info?: {
                              bounce_rate?: ...;
                              pages_per_visit?: ...;
                              time_on_site?: ...;
                              top_organic_keywords?: ...;
                              traffic_by_country?: ...;
                              traffic_by_source?: ...;
                              traffic_trends?: ...;
                              visits_per_month?: ...;
                          };
                          truebiz_request_id?: string
                          | null;
                          url?: string | null;
                          warnings?: (...)[];
                          web_presence_report_summary?: string | null;
                          web_presence_report_summary_checklist?: (...)[];
                          website_content?: {
                              addresses?: ...;
                              blog_or_news_last_updated_date?: ...;
                              compliance?: ...;
                              content_inconsistencies?: ...;
                              customers?: ...;
                              deadlinks?: ...;
                              description?: ...;
                              email?: ...;
                              evaluated_url?: ...;
                              harmful_content?: ...;
                              has_placeholder_text?: ...;
                              has_stock_images?: ...;
                              historic_screenshots_urls_and_timestamps?: ...;
                              industries?: ...;
                              is_website_authentic?: ...;
                              keyword_contexts?: ...;
                              language?: ...;
                              mlm_links?: ...;
                              number_of_bad_policies?: ...;
                              number_of_mlm_links?: ...;
                              pages_linked?: ...;
                              phone_numbers?: ...;
                              policy_analysis?: ...;
                              real_website?: ...;
                              screenshot_url?: ...;
                              summary_notes?: ...;
                              title?: ...;
                              website_authenticity_reasoning?: ...;
                              website_last_updated_date?: ...;
                          };
                      };
                  };
                  id: string;
                  lifecycleStatusDescription: string
                  | null;
                  resultDescription: string | null;
              } & {
                  existed: boolean;
                  previousLifecycleStatus: | "PROFILE_NOT_SUBMITTED"
                  | "ONBOARDING_SESSIONS_PENDING"
                  | "READY_FOR_REVIEW"
                  | "ADDITIONAL_INFO_REQUESTED"
                  | "MONITORING_UPDATES"
                  | "SESSIONS_EXPIRED"
                  | null;
                  previousResult: | "APPROVED"
                  | "DECLINED"
                  | "REVIEW"
                  | "UNKNOWN"
                  | "DEACTIVATED"
                  | null;
              };
          }
          | { error: ServiceError; ok: false },
      >

    • Parameters

      • __namedParameters: {
            aipriseIds?: string[];
            clientReferenceIds?: string[];
            createdAt?: DbTimestampCriteria;
            ids?: string[];
            orderBy?: DbOrderByCriterion<
                Omit<
                    PgTableWithColumns<
                        {
                            columns: {
                                aipriseId: PgBuildColumn<
                                    "aiprise_business_profile",
                                    SetNotNull<PgTextBuilder<(...)>>,
                                    {
                                        data: string;
                                        dataType: "string";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: true;
                                        tableName: "aiprise_business_profile";
                                    },
                                >;
                                clientReferenceId: PgBuildColumn<
                                    "aiprise_business_profile",
                                    PgTextBuilder<[(...), ...(...)[]]>,
                                    {
                                        data: string;
                                        dataType: "string";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "aiprise_business_profile";
                                    },
                                >;
                                createdAt: PgBuildColumn<
                                    "aiprise_business_profile",
                                    SetHasDefault<SetNotNull<(...)>>,
                                    {
                                        data: Date;
                                        dataType: "object date";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: true;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: true;
                                        tableName: "aiprise_business_profile";
                                    },
                                >;
                                data: PgBuildColumn<
                                    "aiprise_business_profile",
                                    Set$Type<SetNotNull<(...)>, AiPriseBusinessProfileData>,
                                    {
                                        data: AiPriseBusinessProfileData;
                                        dataType: "object json";
                                        driverParam: unknown;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: true;
                                        tableName: "aiprise_business_profile";
                                    },
                                >;
                                deletedAt: PgBuildColumn<
                                    "aiprise_business_profile",
                                    PgTimestampBuilder,
                                    {
                                        data: Date;
                                        dataType: "object date";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "aiprise_business_profile";
                                    },
                                >;
                                emailAddresses: PgBuildColumn<
                                    "aiprise_business_profile",
                                    SetDimensions<PgTextBuilder<(...)>, 1>,
                                    {
                                        data: (...)[];
                                        dataType: "string";
                                        driverParam: (...) | (...);
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "aiprise_business_profile";
                                    },
                                >;
                                externalId: PgBuildColumn<
                                    "aiprise_business_profile",
                                    SetHasRuntimeDefault<SetNotNull<(...)>>,
                                    {
                                        data: string;
                                        dataType: "string";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: true;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: true;
                                        tableName: "aiprise_business_profile";
                                    },
                                >;
                                id: PgBuildColumn<
                                    "aiprise_business_profile",
                                    HasIdentity<SetIsPrimaryKey<(...)>, "byDefault">,
                                    {
                                        data: number;
                                        dataType: "number int32";
                                        driverParam: (...) | (...);
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: true;
                                        hasRuntimeDefault: false;
                                        identity: "byDefault";
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: true;
                                        tableName: "aiprise_business_profile";
                                    },
                                >;
                                lifecycleStatus: PgBuildColumn<
                                    "aiprise_business_profile",
                                    Set$Type<
                                        PgTextBuilder<(...)>,
                                        (...) | (...) | (...) | (...) | (...) | (...),
                                    >,
                                    {
                                        data: (...) | (...) | (...) | (...) | (...) | (...);
                                        dataType: "string";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "aiprise_business_profile";
                                    },
                                >;
                                name: PgBuildColumn<
                                    "aiprise_business_profile",
                                    PgTextBuilder<[(...), ...(...)[]]>,
                                    {
                                        data: string;
                                        dataType: "string";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "aiprise_business_profile";
                                    },
                                >;
                                phoneNumbers: PgBuildColumn<
                                    "aiprise_business_profile",
                                    SetDimensions<PgTextBuilder<(...)>, 1>,
                                    {
                                        data: (...)[];
                                        dataType: "string";
                                        driverParam: (...) | (...);
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "aiprise_business_profile";
                                    },
                                >;
                                profileUpdatedAt: PgBuildColumn<
                                    "aiprise_business_profile",
                                    PgTimestampBuilder,
                                    {
                                        data: Date;
                                        dataType: "object date";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "aiprise_business_profile";
                                    },
                                >;
                                result: PgBuildColumn<
                                    "aiprise_business_profile",
                                    Set$Type<PgTextBuilder<(...)>, (...) | (...) | (...) | (...) | (...)>,
                                    {
                                        data: (...) | (...) | (...) | (...) | (...);
                                        dataType: "string";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: false;
                                        tableName: "aiprise_business_profile";
                                    },
                                >;
                                searchDocument: PgBuildColumn<
                                    "aiprise_business_profile",
                                    SetHasGenerated<SetNotNull<(...)>>,
                                    {
                                        data: string;
                                        dataType: "string";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: true;
                                        hasDefault: true;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: true;
                                        tableName: "aiprise_business_profile";
                                    },
                                >;
                                syncedAt: PgBuildColumn<
                                    "aiprise_business_profile",
                                    SetNotNull<PgTimestampBuilder>,
                                    {
                                        data: Date;
                                        dataType: "object date";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: false;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: true;
                                        tableName: "aiprise_business_profile";
                                    },
                                >;
                                updatedAt: PgBuildColumn<
                                    "aiprise_business_profile",
                                    SetHasDefault<SetHasDefault<(...)>>,
                                    {
                                        data: Date;
                                        dataType: "object date";
                                        driverParam: string;
                                        enumValues: undefined;
                                        generated: undefined;
                                        hasDefault: true;
                                        hasRuntimeDefault: false;
                                        identity: undefined;
                                        isAutoincrement: false;
                                        isPrimaryKey: false;
                                        name: string;
                                        notNull: true;
                                        tableName: "aiprise_business_profile";
                                    },
                                >;
                            };
                            dialect: "pg";
                            isAlias: false;
                            name: "aiprise_business_profile";
                            schema: "b2b";
                        },
                    >,
                    "enableRLS",
                >,
                "profileUpdatedAt"
                | "syncedAt"
                | "createdAt"
                | "updatedAt",
            >[];
            page?: number;
            pageSize?: number;
            q?: string;
            results?: NonNullable<
                "APPROVED"
                | "DECLINED"
                | "REVIEW"
                | "UNKNOWN"
                | "DEACTIVATED"
                | null,
            >[];
            updatedAt?: DbTimestampCriteria;
        }
        • OptionalaipriseIds?: string[]
        • OptionalclientReferenceIds?: string[]
        • OptionalcreatedAt?: DbTimestampCriteria
        • Optionalids?: string[]
        • OptionalorderBy?: DbOrderByCriterion<
              Omit<
                  PgTableWithColumns<
                      {
                          columns: {
                              aipriseId: PgBuildColumn<
                                  "aiprise_business_profile",
                                  SetNotNull<PgTextBuilder<(...)>>,
                                  {
                                      data: string;
                                      dataType: "string";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "aiprise_business_profile";
                                  },
                              >;
                              clientReferenceId: PgBuildColumn<
                                  "aiprise_business_profile",
                                  PgTextBuilder<[(...), ...(...)[]]>,
                                  {
                                      data: string;
                                      dataType: "string";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "aiprise_business_profile";
                                  },
                              >;
                              createdAt: PgBuildColumn<
                                  "aiprise_business_profile",
                                  SetHasDefault<SetNotNull<(...)>>,
                                  {
                                      data: Date;
                                      dataType: "object date";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: true;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "aiprise_business_profile";
                                  },
                              >;
                              data: PgBuildColumn<
                                  "aiprise_business_profile",
                                  Set$Type<SetNotNull<(...)>, AiPriseBusinessProfileData>,
                                  {
                                      data: AiPriseBusinessProfileData;
                                      dataType: "object json";
                                      driverParam: unknown;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "aiprise_business_profile";
                                  },
                              >;
                              deletedAt: PgBuildColumn<
                                  "aiprise_business_profile",
                                  PgTimestampBuilder,
                                  {
                                      data: Date;
                                      dataType: "object date";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "aiprise_business_profile";
                                  },
                              >;
                              emailAddresses: PgBuildColumn<
                                  "aiprise_business_profile",
                                  SetDimensions<PgTextBuilder<(...)>, 1>,
                                  {
                                      data: (...)[];
                                      dataType: "string";
                                      driverParam: (...) | (...);
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "aiprise_business_profile";
                                  },
                              >;
                              externalId: PgBuildColumn<
                                  "aiprise_business_profile",
                                  SetHasRuntimeDefault<SetNotNull<(...)>>,
                                  {
                                      data: string;
                                      dataType: "string";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: true;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "aiprise_business_profile";
                                  },
                              >;
                              id: PgBuildColumn<
                                  "aiprise_business_profile",
                                  HasIdentity<SetIsPrimaryKey<(...)>, "byDefault">,
                                  {
                                      data: number;
                                      dataType: "number int32";
                                      driverParam: (...) | (...);
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: true;
                                      hasRuntimeDefault: false;
                                      identity: "byDefault";
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "aiprise_business_profile";
                                  },
                              >;
                              lifecycleStatus: PgBuildColumn<
                                  "aiprise_business_profile",
                                  Set$Type<
                                      PgTextBuilder<(...)>,
                                      (...) | (...) | (...) | (...) | (...) | (...),
                                  >,
                                  {
                                      data: (...) | (...) | (...) | (...) | (...) | (...);
                                      dataType: "string";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "aiprise_business_profile";
                                  },
                              >;
                              name: PgBuildColumn<
                                  "aiprise_business_profile",
                                  PgTextBuilder<[(...), ...(...)[]]>,
                                  {
                                      data: string;
                                      dataType: "string";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "aiprise_business_profile";
                                  },
                              >;
                              phoneNumbers: PgBuildColumn<
                                  "aiprise_business_profile",
                                  SetDimensions<PgTextBuilder<(...)>, 1>,
                                  {
                                      data: (...)[];
                                      dataType: "string";
                                      driverParam: (...) | (...);
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "aiprise_business_profile";
                                  },
                              >;
                              profileUpdatedAt: PgBuildColumn<
                                  "aiprise_business_profile",
                                  PgTimestampBuilder,
                                  {
                                      data: Date;
                                      dataType: "object date";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "aiprise_business_profile";
                                  },
                              >;
                              result: PgBuildColumn<
                                  "aiprise_business_profile",
                                  Set$Type<PgTextBuilder<(...)>, (...) | (...) | (...) | (...) | (...)>,
                                  {
                                      data: (...) | (...) | (...) | (...) | (...);
                                      dataType: "string";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: false;
                                      tableName: "aiprise_business_profile";
                                  },
                              >;
                              searchDocument: PgBuildColumn<
                                  "aiprise_business_profile",
                                  SetHasGenerated<SetNotNull<(...)>>,
                                  {
                                      data: string;
                                      dataType: "string";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: true;
                                      hasDefault: true;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "aiprise_business_profile";
                                  },
                              >;
                              syncedAt: PgBuildColumn<
                                  "aiprise_business_profile",
                                  SetNotNull<PgTimestampBuilder>,
                                  {
                                      data: Date;
                                      dataType: "object date";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: false;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "aiprise_business_profile";
                                  },
                              >;
                              updatedAt: PgBuildColumn<
                                  "aiprise_business_profile",
                                  SetHasDefault<SetHasDefault<(...)>>,
                                  {
                                      data: Date;
                                      dataType: "object date";
                                      driverParam: string;
                                      enumValues: undefined;
                                      generated: undefined;
                                      hasDefault: true;
                                      hasRuntimeDefault: false;
                                      identity: undefined;
                                      isAutoincrement: false;
                                      isPrimaryKey: false;
                                      name: string;
                                      notNull: true;
                                      tableName: "aiprise_business_profile";
                                  },
                              >;
                          };
                          dialect: "pg";
                          isAlias: false;
                          name: "aiprise_business_profile";
                          schema: "b2b";
                      },
                  >,
                  "enableRLS",
              >,
              "profileUpdatedAt"
              | "syncedAt"
              | "createdAt"
              | "updatedAt",
          >[]
        • Optionalpage?: number

          Defaults to 1

        • OptionalpageSize?: number

          Defaults to 50

        • Optionalq?: string

          Free-text lookup, OR of: exact aipriseId, exact clientReferenceId, case-insensitive substring of name or any payload email, and (when the query carries 5+ digits) a digit-normalized match on any payload phone.

        • Optionalresults?: NonNullable<
              "APPROVED"
              | "DECLINED"
              | "REVIEW"
              | "UNKNOWN"
              | "DEACTIVATED"
              | null,
          >[]
        • OptionalupdatedAt?: DbTimestampCriteria

      Returns Promise<
          {
              ok: true;
              value: {
                  hasNext: boolean;
                  items: AiPriseBusinessProfileShadow[];
                  total: number;
              };
          },
      >

    Settings
    Member Visibility

    On This Page
    Constructors
    Properties
    Methods