Determine the customer associated with a job (project) via NetSuite SuiteTalk

netsuite_determine_customer_for_job.rb

# Author <mike@suitesync.io>
# More info: http://mikebian.co/notes-on-working-with-jobs-projects-using-the-suitetalk-netsuite-api/

ns_job_internal_id = 123

mapping_search = NetSuite::Records::Job.search(
  criteria: {
    basic: [
      {
        field: 'internalId',
        operator: 'anyOf',
        value: [ ns_job_internal_id ]
      }

      # NOTE there's no mainLine option for job search
    ]
  },

  columns: {
    'listRel:basic' => {
      'platformCommon:internalId/' => {},
      'platformCommon:customer/' => {},
    }
  },

  preferences: {
    page_size: 1_000,
    body_fields_only: true
  }
)

mapping_search.results.first.customer.internal_id