Class AiPriseUserProfileService

constructor

• new AiPriseUserProfileService(
      args: {
          aiPriseClient: Pick<AiPriseClient, "getUserProfile">;
          db: B2bDatabase;
      },
  ): AiPriseUserProfileService

  Parameters

  • args: { aiPriseClient: Pick<AiPriseClient, "getUserProfile">; db: B2bDatabase }

  Returns AiPriseUserProfileService

Staticinstance

get

• get(
      args: { id: string },
  ): Promise<{ ok: true; value: AiPriseUserProfileShadow | null }>

  Parameters

  • args: { id: string }

  Returns Promise<{ ok: true; value: AiPriseUserProfileShadow | null }>

getByAipriseId

• getByAipriseId(
      args: { aipriseId: string },
  ): Promise<{ ok: true; value: AiPriseUserProfileShadow | null }>

  Callers hold AiPrise user_profile_ids — this is the hot path.

  Parameters

  • args: { aipriseId: string }

  Returns Promise<{ ok: true; value: AiPriseUserProfileShadow | null }>

refresh

• refresh(
      args: { aipriseId: string },
  ): Promise<
      | {
          ok: true;
          value: Omit<
              SelectAiPriseUserProfile,
              | "id"
              | "externalId"
              | "data"
              | "deletedAt"
              | "emailAddress"
              | "phoneNumber",
          > & {
              data: {
                  address?: | {
                      address_city?: string;
                      address_country?: string;
                      address_state?: string;
                      address_street_1?: string;
                      address_street_2?: string;
                      address_zip_code?: string;
                  }
                  | null;
                  client_reference_data?: Record<string, never>;
                  client_reference_id?: string;
                  date_of_birth?: string;
                  email_address?: string;
                  events_callback_url?: string;
                  first_name?: string | null;
                  full_name?: string | null;
                  last_name?: string | null;
                  middle_name?: string | null;
                  phone_number?: string;
                  phone_number_parts?:
                      | {
                          countryCode?: string
                          | null;
                          number?: string | null;
                          phoneCode?: string | null;
                      }
                      | null;
                  questions_response?: {
                      [key: string]: { [key: string]: (...)
                      | (...)
                      | (...) };
                  };
                  second_last_name?: string
                  | null;
                  user_profile_id?: string;
                  user_profile_result?:
                      | "APPROVED"
                      | "DECLINED"
                      | "REVIEW"
                      | "UNKNOWN"
                      | "DEACTIVATED";
                  verification_session_ids?: string[];
              } & {
                  additional_information?: {
                      additional_info_response_type?: | (...)
                      | (...)
                      | (...)
                      | (...)
                      | (...);
                      additional_info_type?: (...) | (...);
                      data?: (...) | (...) | (...) | (...) | (...);
                  }[];
                  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?: (...)[];
                  }
                  | null;
                  created_at?: number;
                  face_liveness_info?: | {
                      check_summary?: Record<(...), (...)>;
                      result:
                          | "APPROVED"
                          | "DECLINED"
                          | "REVIEW"
                          | "UNKNOWN"
                          | "FOUND"
                          | "NOT_FOUND";
                      section_id?: string;
                      source?: string
                      | null;
                      status?:
                          | "NOT_STARTED"
                          | "RUNNING"
                          | "PENDING"
                          | "FAILED"
                          | "COMPLETED"
                          | "SUBMITTED"
                          | null;
                      status_reasons?: (...)[];
                      warnings?: (...)[];
                  }
                  | null;
                  face_match_info?: | {
                      check_summary?: Record<(...), (...)>;
                      face_match_score?: number | null;
                      result:
                          | "APPROVED"
                          | "DECLINED"
                          | "REVIEW"
                          | "UNKNOWN"
                          | "FOUND"
                          | "NOT_FOUND";
                      section_id?: string;
                      status?: | "NOT_STARTED"
                      | "RUNNING"
                      | "PENDING"
                      | "FAILED"
                      | "COMPLETED"
                      | "SUBMITTED"
                      | null;
                      status_reasons?: (...)[];
                      warnings?: (...)[];
                  }
                  | null;
                  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?: (...)[];
                  }
                  | null;
                  id_info?: | {
                      address?: | {
                          additional_info?: ...;
                          full_address?: ...;
                          parsed_address?: ...;
                          source?: ...;
                      }
                      | null;
                      birth_date?: string;
                      check_summary?: Record<(...), (...)>;
                      document_details?: {
                          barcode_data?: ...;
                          mrz_data?: ...;
                          ocr_data?: ...;
                      };
                      field_info?: { [key: ...]: ... }
                      | null;
                      first_name?: string;
                      full_name?: string;
                      gender?: string;
                      id_expiry_date?: string;
                      id_issue_date?: string;
                      id_number?: string;
                      id_type?:
                          | "NATIONAL_ID"
                          | "ID_CARD"
                          | "PASSPORT"
                          | "DRIVER_LICENSE"
                          | "RESIDENT_CARD"
                          | "VISA"
                          | "VOTER_ID"
                          | "TAX_ID"
                          | "COLOMBIA_PPT"
                          | "GHANA_CARD"
                          | "GHANA_SSNIT_CARD"
                          | "KENYA_ALIEN_CARD"
                          | "NATIONAL_ID_NUMBER"
                          | "PASSPORT_NUMBER"
                          | "BVN"
                          | "VOTER_ID_NUMBER"
                          | "DRIVER_LICENSE_NUMBER"
                          | "TAX_ID_NUMBER"
                          | "NIN"
                          | "SSN9"
                          | "SSN4"
                          | "SSNIT"
                          | "KRA_PIN"
                          | "ALIEN_CARD_NUMBER"
                          | "COLOMBIA_PPT_NUMBER"
                          | "GHANA_CARD_NUMBER";
                      issue_country?: string;
                      issue_country_code?: string;
                      issue_state?: string;
                      issue_state_code?: string;
                      last_name?: string;
                      lookup_details?: Record<(...), (...)>;
                      middle_name?: string;
                      nationality?: string;
                      nationality_code?: string;
                      personal_number?: string;
                      result:
                          | "APPROVED"
                          | "DECLINED"
                          | "REVIEW"
                          | "UNKNOWN"
                          | "FOUND"
                          | "NOT_FOUND";
                      second_last_name?: string;
                      section_id?: string;
                      status?: | "NOT_STARTED"
                      | "RUNNING"
                      | "PENDING"
                      | "FAILED"
                      | "COMPLETED"
                      | "SUBMITTED"
                      | null;
                      status_reasons?: (...)[];
                      warnings?: (...)[];
                  }
                  | null;
                  lookup_info?: {
                      data?: (...)
                      | (...)
                      | (...);
                      database_name?: (...) | (...) | (...);
                      result?: (...) | (...) | (...) | (...) | (...) | (...);
                      section_id?: (...) | (...);
                      status?: (...) | (...) | (...) | (...) | (...) | (...) | (...) | (...);
                      status_reasons?: (...) | (...) | (...);
                      title?: (...) | (...) | (...);
                      warnings?: (...) | (...) | (...);
                  }[];
                  risk_info?: | {
                      decisioning?: {
                          result?: ...;
                          rules_evaluated?: ...;
                          section_id?: ...;
                      };
                      scoring?: {
                          risk_level?: ...;
                          rules_evaluated?: ...;
                          score?: ...;
                          section_id?: ...;
                      };
                  }
                  | null;
                  updated_at?: number;
              };
              id: string;
              resultDescription: string
              | null;
          } & {
              previousResult: | "APPROVED"
              | "DECLINED"
              | "REVIEW"
              | "UNKNOWN"
              | "DEACTIVATED"
              | null;
          };
      }
      | { error: ServiceError; ok: false },
  >

  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<
              SelectAiPriseUserProfile,
              | "id"
              | "externalId"
              | "data"
              | "deletedAt"
              | "emailAddress"
              | "phoneNumber",
          > & {
              data: {
                  address?: | {
                      address_city?: string;
                      address_country?: string;
                      address_state?: string;
                      address_street_1?: string;
                      address_street_2?: string;
                      address_zip_code?: string;
                  }
                  | null;
                  client_reference_data?: Record<string, never>;
                  client_reference_id?: string;
                  date_of_birth?: string;
                  email_address?: string;
                  events_callback_url?: string;
                  first_name?: string | null;
                  full_name?: string | null;
                  last_name?: string | null;
                  middle_name?: string | null;
                  phone_number?: string;
                  phone_number_parts?:
                      | {
                          countryCode?: string
                          | null;
                          number?: string | null;
                          phoneCode?: string | null;
                      }
                      | null;
                  questions_response?: {
                      [key: string]: { [key: string]: (...)
                      | (...)
                      | (...) };
                  };
                  second_last_name?: string
                  | null;
                  user_profile_id?: string;
                  user_profile_result?:
                      | "APPROVED"
                      | "DECLINED"
                      | "REVIEW"
                      | "UNKNOWN"
                      | "DEACTIVATED";
                  verification_session_ids?: string[];
              } & {
                  additional_information?: {
                      additional_info_response_type?: | (...)
                      | (...)
                      | (...)
                      | (...)
                      | (...);
                      additional_info_type?: (...) | (...);
                      data?: (...) | (...) | (...) | (...) | (...);
                  }[];
                  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?: (...)[];
                  }
                  | null;
                  created_at?: number;
                  face_liveness_info?: | {
                      check_summary?: Record<(...), (...)>;
                      result:
                          | "APPROVED"
                          | "DECLINED"
                          | "REVIEW"
                          | "UNKNOWN"
                          | "FOUND"
                          | "NOT_FOUND";
                      section_id?: string;
                      source?: string
                      | null;
                      status?:
                          | "NOT_STARTED"
                          | "RUNNING"
                          | "PENDING"
                          | "FAILED"
                          | "COMPLETED"
                          | "SUBMITTED"
                          | null;
                      status_reasons?: (...)[];
                      warnings?: (...)[];
                  }
                  | null;
                  face_match_info?: | {
                      check_summary?: Record<(...), (...)>;
                      face_match_score?: number | null;
                      result:
                          | "APPROVED"
                          | "DECLINED"
                          | "REVIEW"
                          | "UNKNOWN"
                          | "FOUND"
                          | "NOT_FOUND";
                      section_id?: string;
                      status?: | "NOT_STARTED"
                      | "RUNNING"
                      | "PENDING"
                      | "FAILED"
                      | "COMPLETED"
                      | "SUBMITTED"
                      | null;
                      status_reasons?: (...)[];
                      warnings?: (...)[];
                  }
                  | null;
                  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?: (...)[];
                  }
                  | null;
                  id_info?: | {
                      address?: | {
                          additional_info?: ...;
                          full_address?: ...;
                          parsed_address?: ...;
                          source?: ...;
                      }
                      | null;
                      birth_date?: string;
                      check_summary?: Record<(...), (...)>;
                      document_details?: {
                          barcode_data?: ...;
                          mrz_data?: ...;
                          ocr_data?: ...;
                      };
                      field_info?: { [key: ...]: ... }
                      | null;
                      first_name?: string;
                      full_name?: string;
                      gender?: string;
                      id_expiry_date?: string;
                      id_issue_date?: string;
                      id_number?: string;
                      id_type?:
                          | "NATIONAL_ID"
                          | "ID_CARD"
                          | "PASSPORT"
                          | "DRIVER_LICENSE"
                          | "RESIDENT_CARD"
                          | "VISA"
                          | "VOTER_ID"
                          | "TAX_ID"
                          | "COLOMBIA_PPT"
                          | "GHANA_CARD"
                          | "GHANA_SSNIT_CARD"
                          | "KENYA_ALIEN_CARD"
                          | "NATIONAL_ID_NUMBER"
                          | "PASSPORT_NUMBER"
                          | "BVN"
                          | "VOTER_ID_NUMBER"
                          | "DRIVER_LICENSE_NUMBER"
                          | "TAX_ID_NUMBER"
                          | "NIN"
                          | "SSN9"
                          | "SSN4"
                          | "SSNIT"
                          | "KRA_PIN"
                          | "ALIEN_CARD_NUMBER"
                          | "COLOMBIA_PPT_NUMBER"
                          | "GHANA_CARD_NUMBER";
                      issue_country?: string;
                      issue_country_code?: string;
                      issue_state?: string;
                      issue_state_code?: string;
                      last_name?: string;
                      lookup_details?: Record<(...), (...)>;
                      middle_name?: string;
                      nationality?: string;
                      nationality_code?: string;
                      personal_number?: string;
                      result:
                          | "APPROVED"
                          | "DECLINED"
                          | "REVIEW"
                          | "UNKNOWN"
                          | "FOUND"
                          | "NOT_FOUND";
                      second_last_name?: string;
                      section_id?: string;
                      status?: | "NOT_STARTED"
                      | "RUNNING"
                      | "PENDING"
                      | "FAILED"
                      | "COMPLETED"
                      | "SUBMITTED"
                      | null;
                      status_reasons?: (...)[];
                      warnings?: (...)[];
                  }
                  | null;
                  lookup_info?: {
                      data?: (...)
                      | (...)
                      | (...);
                      database_name?: (...) | (...) | (...);
                      result?: (...) | (...) | (...) | (...) | (...) | (...);
                      section_id?: (...) | (...);
                      status?: (...) | (...) | (...) | (...) | (...) | (...) | (...) | (...);
                      status_reasons?: (...) | (...) | (...);
                      title?: (...) | (...) | (...);
                      warnings?: (...) | (...) | (...);
                  }[];
                  risk_info?: | {
                      decisioning?: {
                          result?: ...;
                          rules_evaluated?: ...;
                          section_id?: ...;
                      };
                      scoring?: {
                          risk_level?: ...;
                          rules_evaluated?: ...;
                          score?: ...;
                          section_id?: ...;
                      };
                  }
                  | null;
                  updated_at?: number;
              };
              id: string;
              resultDescription: string
              | null;
          } & {
              previousResult: | "APPROVED"
              | "DECLINED"
              | "REVIEW"
              | "UNKNOWN"
              | "DEACTIVATED"
              | null;
          };
      }
      | { error: ServiceError; ok: false },
  >

search

• search(
      __namedParameters: {
          aipriseIds?: string[];
          clientReferenceIds?: string[];
          createdAt?: DbTimestampCriteria;
          ids?: string[];
          orderBy?: DbOrderByCriterion<
              Omit<
                  PgTableWithColumns<
                      {
                          columns: {
                              aipriseId: PgBuildColumn<
                                  "aiprise_user_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_user_profile";
                                  },
                              >;
                              clientReferenceId: PgBuildColumn<
                                  "aiprise_user_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_user_profile";
                                  },
                              >;
                              createdAt: PgBuildColumn<
                                  "aiprise_user_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_user_profile";
                                  },
                              >;
                              data: PgBuildColumn<
                                  "aiprise_user_profile",
                                  Set$Type<SetNotNull<(...)>, AiPriseUserProfileData>,
                                  {
                                      data: AiPriseUserProfileData;
                                      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_user_profile";
                                  },
                              >;
                              deletedAt: PgBuildColumn<
                                  "aiprise_user_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_user_profile";
                                  },
                              >;
                              emailAddress: PgBuildColumn<
                                  "aiprise_user_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_user_profile";
                                  },
                              >;
                              externalId: PgBuildColumn<
                                  "aiprise_user_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_user_profile";
                                  },
                              >;
                              id: PgBuildColumn<
                                  "aiprise_user_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_user_profile";
                                  },
                              >;
                              name: PgBuildColumn<
                                  "aiprise_user_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_user_profile";
                                  },
                              >;
                              phoneNumber: PgBuildColumn<
                                  "aiprise_user_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_user_profile";
                                  },
                              >;
                              profileUpdatedAt: PgBuildColumn<
                                  "aiprise_user_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_user_profile";
                                  },
                              >;
                              result: PgBuildColumn<
                                  "aiprise_user_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_user_profile";
                                  },
                              >;
                              searchDocument: PgBuildColumn<
                                  "aiprise_user_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_user_profile";
                                  },
                              >;
                              syncedAt: PgBuildColumn<
                                  "aiprise_user_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_user_profile";
                                  },
                              >;
                              updatedAt: PgBuildColumn<
                                  "aiprise_user_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_user_profile";
                                  },
                              >;
                          };
                          dialect: "pg";
                          isAlias: false;
                          name: "aiprise_user_profile";
                          schema: "b2b";
                      },
                  >,
                  "enableRLS",
              >,
              "profileUpdatedAt"
              | "syncedAt"
              | "createdAt"
              | "updatedAt",
          >[];
          page?: number;
          pageSize?: number;
          q?: string;
          results?: NonNullable<
              "APPROVED"
              | "DECLINED"
              | "REVIEW"
              | "UNKNOWN"
              | "DEACTIVATED"
              | null,
          >[];
          updatedAt?: DbTimestampCriteria;
      },
  ): Promise<
      {
          ok: true;
          value: {
              hasNext: boolean;
              items: AiPriseUserProfileShadow[];
              total: number;
          };
      },
  >

  Parameters

  • __namedParameters: {
        aipriseIds?: string[];
        clientReferenceIds?: string[];
        createdAt?: DbTimestampCriteria;
        ids?: string[];
        orderBy?: DbOrderByCriterion<
            Omit<
                PgTableWithColumns<
                    {
                        columns: {
                            aipriseId: PgBuildColumn<
                                "aiprise_user_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_user_profile";
                                },
                            >;
                            clientReferenceId: PgBuildColumn<
                                "aiprise_user_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_user_profile";
                                },
                            >;
                            createdAt: PgBuildColumn<
                                "aiprise_user_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_user_profile";
                                },
                            >;
                            data: PgBuildColumn<
                                "aiprise_user_profile",
                                Set$Type<SetNotNull<(...)>, AiPriseUserProfileData>,
                                {
                                    data: AiPriseUserProfileData;
                                    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_user_profile";
                                },
                            >;
                            deletedAt: PgBuildColumn<
                                "aiprise_user_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_user_profile";
                                },
                            >;
                            emailAddress: PgBuildColumn<
                                "aiprise_user_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_user_profile";
                                },
                            >;
                            externalId: PgBuildColumn<
                                "aiprise_user_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_user_profile";
                                },
                            >;
                            id: PgBuildColumn<
                                "aiprise_user_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_user_profile";
                                },
                            >;
                            name: PgBuildColumn<
                                "aiprise_user_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_user_profile";
                                },
                            >;
                            phoneNumber: PgBuildColumn<
                                "aiprise_user_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_user_profile";
                                },
                            >;
                            profileUpdatedAt: PgBuildColumn<
                                "aiprise_user_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_user_profile";
                                },
                            >;
                            result: PgBuildColumn<
                                "aiprise_user_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_user_profile";
                                },
                            >;
                            searchDocument: PgBuildColumn<
                                "aiprise_user_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_user_profile";
                                },
                            >;
                            syncedAt: PgBuildColumn<
                                "aiprise_user_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_user_profile";
                                },
                            >;
                            updatedAt: PgBuildColumn<
                                "aiprise_user_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_user_profile";
                                },
                            >;
                        };
                        dialect: "pg";
                        isAlias: false;
                        name: "aiprise_user_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_user_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_user_profile";
                              },
                          >;
                          clientReferenceId: PgBuildColumn<
                              "aiprise_user_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_user_profile";
                              },
                          >;
                          createdAt: PgBuildColumn<
                              "aiprise_user_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_user_profile";
                              },
                          >;
                          data: PgBuildColumn<
                              "aiprise_user_profile",
                              Set$Type<SetNotNull<(...)>, AiPriseUserProfileData>,
                              {
                                  data: AiPriseUserProfileData;
                                  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_user_profile";
                              },
                          >;
                          deletedAt: PgBuildColumn<
                              "aiprise_user_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_user_profile";
                              },
                          >;
                          emailAddress: PgBuildColumn<
                              "aiprise_user_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_user_profile";
                              },
                          >;
                          externalId: PgBuildColumn<
                              "aiprise_user_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_user_profile";
                              },
                          >;
                          id: PgBuildColumn<
                              "aiprise_user_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_user_profile";
                              },
                          >;
                          name: PgBuildColumn<
                              "aiprise_user_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_user_profile";
                              },
                          >;
                          phoneNumber: PgBuildColumn<
                              "aiprise_user_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_user_profile";
                              },
                          >;
                          profileUpdatedAt: PgBuildColumn<
                              "aiprise_user_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_user_profile";
                              },
                          >;
                          result: PgBuildColumn<
                              "aiprise_user_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_user_profile";
                              },
                          >;
                          searchDocument: PgBuildColumn<
                              "aiprise_user_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_user_profile";
                              },
                          >;
                          syncedAt: PgBuildColumn<
                              "aiprise_user_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_user_profile";
                              },
                          >;
                          updatedAt: PgBuildColumn<
                              "aiprise_user_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_user_profile";
                              },
                          >;
                      };
                      dialect: "pg";
                      isAlias: false;
                      name: "aiprise_user_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 the payload email, and (when the query carries 5+ digits) a digit-normalized match on the payload phone.

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

    • OptionalupdatedAt?: DbTimestampCriteria

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