jobs

Creates, updates, deletes, gets or lists a jobs resource.

Overview

Name	`jobs`
Type	Resource
Id	`google.jobs.jobs`

Fields

The following fields are returned by SELECT queries:

get
list

Successful response

Name	Datatype	Description
`name`	`string`	Required during job update. The resource name for the job. This is generated by the service when a job is created. The format is "projects/{project_id}/tenants/{tenant_id}/jobs/{job_id}". For example, "projects/foo/tenants/bar/jobs/baz". Use of this field in job queries and API calls is preferred over the use of requisition_id since this value is unique.
`addresses`	`array`	Strongly recommended for the best service experience. Location(s) where the employer is looking to hire for this job posting. Specifying the full street address(es) of the hiring location enables better API results, especially job searches by commute time. At most 50 locations are allowed for best search performance. If a job has more locations, it is suggested to split it into multiple jobs with unique requisition_ids (e.g. 'ReqA' becomes 'ReqA-1', 'ReqA-2', and so on.) as multiple jobs with the same company, language_code and requisition_id are not allowed. If the original requisition_id must be preserved, a custom field should be used for storage. It is also suggested to group the locations that close to each other in the same job for better search experience. Jobs with multiple addresses must have their addresses with the same LocationType to allow location filtering to work properly. (For example, a Job with addresses "1600 Amphitheatre Parkway, Mountain View, CA, USA" and "London, UK" may not have location filters applied correctly at search time since the first is a LocationType.STREET_ADDRESS and the second is a LocationType.LOCALITY.) If a job needs to have multiple addresses, it is suggested to split it into multiple jobs with same LocationTypes. The maximum number of allowed characters is 500.
`applicationInfo`	`object`	Job application information. (id: ApplicationInfo)
`company`	`string`	Required. The resource name of the company listing the job. The format is "projects/{project_id}/tenants/{tenant_id}/companies/{company_id}". For example, "projects/foo/tenants/bar/companies/baz".
`companyDisplayName`	`string`	Output only. Display name of the company listing the job.
`compensationInfo`	`object`	Job compensation information (a.k.a. "pay rate") i.e., the compensation that will paid to the employee. (id: CompensationInfo)
`customAttributes`	`object`	A map of fields to hold both filterable and non-filterable custom job attributes that are not covered by the provided structured fields. The keys of the map are strings up to 64 bytes and must match the pattern: `a-zA-Z*`. For example, key0LikeThis or KEY_1_LIKE_THIS. At most 100 filterable and at most 100 unfilterable keys are supported. For filterable `string_values`, across all keys at most 200 values are allowed, with each string no more than 255 characters. For unfilterable `string_values`, the maximum total size of `string_values` across all keys is 50KB.
`degreeTypes`	`array`	The desired education degrees for the job, such as Bachelors, Masters.
`department`	`string`	The department or functional area within the company with the open position. The maximum number of allowed characters is 255.
`derivedInfo`	`object`	Output only. Derived details about the job posting. (id: JobDerivedInfo)
`description`	`string`	Required. The description of the job, which typically includes a multi-paragraph description of the company and related information. Separate fields are provided on the job object for responsibilities, qualifications, and other job characteristics. Use of these separate job fields is recommended. This field accepts and sanitizes HTML input, and also accepts bold, italic, ordered list, and unordered list markup tags. The maximum number of allowed characters is 100,000.
`employmentTypes`	`array`	The employment type(s) of a job, for example, full time or part time.
`incentives`	`string`	A description of bonus, commission, and other compensation incentives associated with the job not including salary or pay. The maximum number of allowed characters is 10,000.
`jobBenefits`	`array`	The benefits included with the job.
`jobEndTime`	`string (google-datetime)`	The end timestamp of the job. Typically this field is used for contracting engagements. Invalid timestamps are ignored.
`jobLevel`	`string`	The experience level associated with the job, such as "Entry Level".
`jobStartTime`	`string (google-datetime)`	The start timestamp of the job in UTC time zone. Typically this field is used for contracting engagements. Invalid timestamps are ignored.
`languageCode`	`string`	The language of the posting. This field is distinct from any requirements for fluency that are associated with the job. Language codes must be in BCP-47 format, such as "en-US" or "sr-Latn". For more information, see Tags for Identifying Languages{: class="external" target="_blank" }. If this field is unspecified and Job.description is present, detected language code based on Job.description is assigned, otherwise defaults to 'en_US'.
`postingCreateTime`	`string (google-datetime)`	Output only. The timestamp when this job posting was created.
`postingExpireTime`	`string (google-datetime)`	Strongly recommended for the best service experience. The expiration timestamp of the job. After this timestamp, the job is marked as expired, and it no longer appears in search results. The expired job can't be listed by the ListJobs API, but it can be retrieved with the GetJob API or updated with the UpdateJob API or deleted with the DeleteJob API. An expired job can be updated and opened again by using a future expiration timestamp. Updating an expired job fails if there is another existing open job with same company, language_code and requisition_id. The expired jobs are retained in our system for 90 days. However, the overall expired job count cannot exceed 3 times the maximum number of open jobs over previous 7 days. If this threshold is exceeded, expired jobs are cleaned out in order of earliest expire time. Expired jobs are no longer accessible after they are cleaned out. Invalid timestamps are ignored, and treated as expire time not provided. If the timestamp is before the instant request is made, the job is treated as expired immediately on creation. This kind of job can not be updated. And when creating a job with past timestamp, the posting_publish_time must be set before posting_expire_time. The purpose of this feature is to allow other objects, such as ApplicationInfo, to refer a job that didn't exist in the system prior to becoming expired. If you want to modify a job that was expired on creation, delete it and create a new one. If this value isn't provided at the time of job creation or is invalid, the job posting expires after 30 days from the job's creation time. For example, if the job was created on 2017/01/01 13:00AM UTC with an unspecified expiration date, the job expires after 2017/01/31 13:00AM UTC. If this value isn't provided on job update, it depends on the field masks set by UpdateJobRequest.update_mask. If the field masks include job_end_time, or the masks are empty meaning that every field is updated, the job posting expires after 30 days from the job's last update time. Otherwise the expiration date isn't updated.
`postingPublishTime`	`string (google-datetime)`	The timestamp this job posting was most recently published. The default value is the time the request arrives at the server. Invalid timestamps are ignored.
`postingRegion`	`string`	The job PostingRegion (for example, state, country) throughout which the job is available. If this field is set, a LocationFilter in a search query within the job region finds this job posting if an exact location match isn't specified. If this field is set to PostingRegion.NATION or PostingRegion.ADMINISTRATIVE_AREA, setting job Job.addresses to the same location level as this field is strongly recommended.
`postingUpdateTime`	`string (google-datetime)`	Output only. The timestamp when this job posting was last updated.
`processingOptions`	`object`	Options for job processing. (id: ProcessingOptions)
`promotionValue`	`integer (int32)`	A promotion value of the job, as determined by the client. The value determines the sort order of the jobs returned when searching for jobs using the featured jobs search call, with higher promotional values being returned first and ties being resolved by relevance sort. Only the jobs with a promotionValue >0 are returned in a FEATURED_JOB_SEARCH. Default value is 0, and negative values are treated as 0.
`qualifications`	`string`	A description of the qualifications required to perform the job. The use of this field is recommended as an alternative to using the more general description field. This field accepts and sanitizes HTML input, and also accepts bold, italic, ordered list, and unordered list markup tags. The maximum number of allowed characters is 10,000.
`requisitionId`	`string`	Required. The requisition ID, also referred to as the posting ID, is assigned by the client to identify a job. This field is intended to be used by clients for client identification and tracking of postings. A job isn't allowed to be created if there is another job with the same company, language_code and requisition_id. The maximum number of allowed characters is 255.
`responsibilities`	`string`	A description of job responsibilities. The use of this field is recommended as an alternative to using the more general description field. This field accepts and sanitizes HTML input, and also accepts bold, italic, ordered list, and unordered list markup tags. The maximum number of allowed characters is 10,000.
`title`	`string`	Required. The title of the job, such as "Software Engineer" The maximum number of allowed characters is 500.
`visibility`	`string`	Deprecated. The job is only visible to the owner. The visibility of the job. Defaults to Visibility.ACCOUNT_ONLY if not specified.

Successful response

Name	Datatype	Description
`name`	`string`	Required during job update. The resource name for the job. This is generated by the service when a job is created. The format is "projects/{project_id}/tenants/{tenant_id}/jobs/{job_id}". For example, "projects/foo/tenants/bar/jobs/baz". Use of this field in job queries and API calls is preferred over the use of requisition_id since this value is unique.
`addresses`	`array`	Strongly recommended for the best service experience. Location(s) where the employer is looking to hire for this job posting. Specifying the full street address(es) of the hiring location enables better API results, especially job searches by commute time. At most 50 locations are allowed for best search performance. If a job has more locations, it is suggested to split it into multiple jobs with unique requisition_ids (e.g. 'ReqA' becomes 'ReqA-1', 'ReqA-2', and so on.) as multiple jobs with the same company, language_code and requisition_id are not allowed. If the original requisition_id must be preserved, a custom field should be used for storage. It is also suggested to group the locations that close to each other in the same job for better search experience. Jobs with multiple addresses must have their addresses with the same LocationType to allow location filtering to work properly. (For example, a Job with addresses "1600 Amphitheatre Parkway, Mountain View, CA, USA" and "London, UK" may not have location filters applied correctly at search time since the first is a LocationType.STREET_ADDRESS and the second is a LocationType.LOCALITY.) If a job needs to have multiple addresses, it is suggested to split it into multiple jobs with same LocationTypes. The maximum number of allowed characters is 500.
`applicationInfo`	`object`	Job application information. (id: ApplicationInfo)
`company`	`string`	Required. The resource name of the company listing the job. The format is "projects/{project_id}/tenants/{tenant_id}/companies/{company_id}". For example, "projects/foo/tenants/bar/companies/baz".
`companyDisplayName`	`string`	Output only. Display name of the company listing the job.
`compensationInfo`	`object`	Job compensation information (a.k.a. "pay rate") i.e., the compensation that will paid to the employee. (id: CompensationInfo)
`customAttributes`	`object`	A map of fields to hold both filterable and non-filterable custom job attributes that are not covered by the provided structured fields. The keys of the map are strings up to 64 bytes and must match the pattern: `a-zA-Z*`. For example, key0LikeThis or KEY_1_LIKE_THIS. At most 100 filterable and at most 100 unfilterable keys are supported. For filterable `string_values`, across all keys at most 200 values are allowed, with each string no more than 255 characters. For unfilterable `string_values`, the maximum total size of `string_values` across all keys is 50KB.
`degreeTypes`	`array`	The desired education degrees for the job, such as Bachelors, Masters.
`department`	`string`	The department or functional area within the company with the open position. The maximum number of allowed characters is 255.
`derivedInfo`	`object`	Output only. Derived details about the job posting. (id: JobDerivedInfo)
`description`	`string`	Required. The description of the job, which typically includes a multi-paragraph description of the company and related information. Separate fields are provided on the job object for responsibilities, qualifications, and other job characteristics. Use of these separate job fields is recommended. This field accepts and sanitizes HTML input, and also accepts bold, italic, ordered list, and unordered list markup tags. The maximum number of allowed characters is 100,000.
`employmentTypes`	`array`	The employment type(s) of a job, for example, full time or part time.
`incentives`	`string`	A description of bonus, commission, and other compensation incentives associated with the job not including salary or pay. The maximum number of allowed characters is 10,000.
`jobBenefits`	`array`	The benefits included with the job.
`jobEndTime`	`string (google-datetime)`	The end timestamp of the job. Typically this field is used for contracting engagements. Invalid timestamps are ignored.
`jobLevel`	`string`	The experience level associated with the job, such as "Entry Level".
`jobStartTime`	`string (google-datetime)`	The start timestamp of the job in UTC time zone. Typically this field is used for contracting engagements. Invalid timestamps are ignored.
`languageCode`	`string`	The language of the posting. This field is distinct from any requirements for fluency that are associated with the job. Language codes must be in BCP-47 format, such as "en-US" or "sr-Latn". For more information, see Tags for Identifying Languages{: class="external" target="_blank" }. If this field is unspecified and Job.description is present, detected language code based on Job.description is assigned, otherwise defaults to 'en_US'.
`postingCreateTime`	`string (google-datetime)`	Output only. The timestamp when this job posting was created.
`postingExpireTime`	`string (google-datetime)`	Strongly recommended for the best service experience. The expiration timestamp of the job. After this timestamp, the job is marked as expired, and it no longer appears in search results. The expired job can't be listed by the ListJobs API, but it can be retrieved with the GetJob API or updated with the UpdateJob API or deleted with the DeleteJob API. An expired job can be updated and opened again by using a future expiration timestamp. Updating an expired job fails if there is another existing open job with same company, language_code and requisition_id. The expired jobs are retained in our system for 90 days. However, the overall expired job count cannot exceed 3 times the maximum number of open jobs over previous 7 days. If this threshold is exceeded, expired jobs are cleaned out in order of earliest expire time. Expired jobs are no longer accessible after they are cleaned out. Invalid timestamps are ignored, and treated as expire time not provided. If the timestamp is before the instant request is made, the job is treated as expired immediately on creation. This kind of job can not be updated. And when creating a job with past timestamp, the posting_publish_time must be set before posting_expire_time. The purpose of this feature is to allow other objects, such as ApplicationInfo, to refer a job that didn't exist in the system prior to becoming expired. If you want to modify a job that was expired on creation, delete it and create a new one. If this value isn't provided at the time of job creation or is invalid, the job posting expires after 30 days from the job's creation time. For example, if the job was created on 2017/01/01 13:00AM UTC with an unspecified expiration date, the job expires after 2017/01/31 13:00AM UTC. If this value isn't provided on job update, it depends on the field masks set by UpdateJobRequest.update_mask. If the field masks include job_end_time, or the masks are empty meaning that every field is updated, the job posting expires after 30 days from the job's last update time. Otherwise the expiration date isn't updated.
`postingPublishTime`	`string (google-datetime)`	The timestamp this job posting was most recently published. The default value is the time the request arrives at the server. Invalid timestamps are ignored.
`postingRegion`	`string`	The job PostingRegion (for example, state, country) throughout which the job is available. If this field is set, a LocationFilter in a search query within the job region finds this job posting if an exact location match isn't specified. If this field is set to PostingRegion.NATION or PostingRegion.ADMINISTRATIVE_AREA, setting job Job.addresses to the same location level as this field is strongly recommended.
`postingUpdateTime`	`string (google-datetime)`	Output only. The timestamp when this job posting was last updated.
`processingOptions`	`object`	Options for job processing. (id: ProcessingOptions)
`promotionValue`	`integer (int32)`	A promotion value of the job, as determined by the client. The value determines the sort order of the jobs returned when searching for jobs using the featured jobs search call, with higher promotional values being returned first and ties being resolved by relevance sort. Only the jobs with a promotionValue >0 are returned in a FEATURED_JOB_SEARCH. Default value is 0, and negative values are treated as 0.
`qualifications`	`string`	A description of the qualifications required to perform the job. The use of this field is recommended as an alternative to using the more general description field. This field accepts and sanitizes HTML input, and also accepts bold, italic, ordered list, and unordered list markup tags. The maximum number of allowed characters is 10,000.
`requisitionId`	`string`	Required. The requisition ID, also referred to as the posting ID, is assigned by the client to identify a job. This field is intended to be used by clients for client identification and tracking of postings. A job isn't allowed to be created if there is another job with the same company, language_code and requisition_id. The maximum number of allowed characters is 255.
`responsibilities`	`string`	A description of job responsibilities. The use of this field is recommended as an alternative to using the more general description field. This field accepts and sanitizes HTML input, and also accepts bold, italic, ordered list, and unordered list markup tags. The maximum number of allowed characters is 10,000.
`title`	`string`	Required. The title of the job, such as "Software Engineer" The maximum number of allowed characters is 500.
`visibility`	`string`	Deprecated. The job is only visible to the owner. The visibility of the job. Defaults to Visibility.ACCOUNT_ONLY if not specified.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
`get`	`select`	`projectsId`, `tenantsId`, `jobsId`		Retrieves the specified job, whose status is OPEN or recently EXPIRED within the last 90 days.
`list`	`select`	`projectsId`, `tenantsId`	`filter`, `pageToken`, `pageSize`, `jobView`	Lists jobs by filter.
`create`	`insert`	`projectsId`, `tenantsId`		Creates a new job. Typically, the job becomes searchable within 10 seconds, but it may take up to 5 minutes.
`batch_create`	`insert`	`projectsId`, `tenantsId`		Begins executing a batch create jobs operation.
`patch`	`update`	`projectsId`, `tenantsId`, `jobsId`	`updateMask`	Updates specified job. Typically, updated contents become visible in search results within 10 seconds, but it may take up to 5 minutes.
`batch_update`	`update`	`projectsId`, `tenantsId`		Begins executing a batch update jobs operation.
`delete`	`delete`	`projectsId`, `tenantsId`, `jobsId`		Deletes the specified job. Typically, the job becomes unsearchable within 10 seconds, but it may take up to 5 minutes.
`batch_delete`	`delete`	`projectsId`, `tenantsId`		Begins executing a batch delete jobs operation.
`search`	`exec`	`projectsId`, `tenantsId`		Searches for jobs using the provided SearchJobsRequest. This call constrains the visibility of jobs present in the database, and only returns jobs that the caller has permission to search against.
`search_for_alert`	`exec`	`projectsId`, `tenantsId`		Searches for jobs using the provided SearchJobsRequest. This API call is intended for the use case of targeting passive job seekers (for example, job seekers who have signed up to receive email alerts about potential job opportunities), it has different algorithmic adjustments that are designed to specifically target passive job seekers. This call constrains the visibility of jobs present in the database, and only returns jobs the caller has permission to search against.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
`jobsId`	`string`
`projectsId`	`string`
`tenantsId`	`string`
`filter`	`string`
`jobView`	`string`
`pageSize`	`integer (int32)`
`pageToken`	`string`
`updateMask`	`string (google-fieldmask)`

`SELECT` examples

get
list

Retrieves the specified job, whose status is OPEN or recently EXPIRED within the last 90 days.

SELECT
name,
addresses,
applicationInfo,
company,
companyDisplayName,
compensationInfo,
customAttributes,
degreeTypes,
department,
derivedInfo,
description,
employmentTypes,
incentives,
jobBenefits,
jobEndTime,
jobLevel,
jobStartTime,
languageCode,
postingCreateTime,
postingExpireTime,
postingPublishTime,
postingRegion,
postingUpdateTime,
processingOptions,
promotionValue,
qualifications,
requisitionId,
responsibilities,
title,
visibility
FROM google.jobs.jobs
WHERE projectsId = '{{ projectsId }}' -- required
AND tenantsId = '{{ tenantsId }}' -- required
AND jobsId = '{{ jobsId }}' -- required;

Lists jobs by filter.

SELECT
name,
addresses,
applicationInfo,
company,
companyDisplayName,
compensationInfo,
customAttributes,
degreeTypes,
department,
derivedInfo,
description,
employmentTypes,
incentives,
jobBenefits,
jobEndTime,
jobLevel,
jobStartTime,
languageCode,
postingCreateTime,
postingExpireTime,
postingPublishTime,
postingRegion,
postingUpdateTime,
processingOptions,
promotionValue,
qualifications,
requisitionId,
responsibilities,
title,
visibility
FROM google.jobs.jobs
WHERE projectsId = '{{ projectsId }}' -- required
AND tenantsId = '{{ tenantsId }}' -- required
AND filter = '{{ filter }}'
AND pageToken = '{{ pageToken }}'
AND pageSize = '{{ pageSize }}'
AND jobView = '{{ jobView }}';

`INSERT` examples

create
batch_create
Manifest

Creates a new job. Typically, the job becomes searchable within 10 seconds, but it may take up to 5 minutes.

INSERT INTO google.jobs.jobs (
data__name,
data__company,
data__requisitionId,
data__title,
data__description,
data__addresses,
data__applicationInfo,
data__jobBenefits,
data__compensationInfo,
data__customAttributes,
data__degreeTypes,
data__department,
data__employmentTypes,
data__incentives,
data__languageCode,
data__jobLevel,
data__promotionValue,
data__qualifications,
data__responsibilities,
data__postingRegion,
data__visibility,
data__jobStartTime,
data__jobEndTime,
data__postingPublishTime,
data__postingExpireTime,
data__processingOptions,
projectsId,
tenantsId
)
SELECT 
'{{ name }}',
'{{ company }}',
'{{ requisitionId }}',
'{{ title }}',
'{{ description }}',
'{{ addresses }}',
'{{ applicationInfo }}',
'{{ jobBenefits }}',
'{{ compensationInfo }}',
'{{ customAttributes }}',
'{{ degreeTypes }}',
'{{ department }}',
'{{ employmentTypes }}',
'{{ incentives }}',
'{{ languageCode }}',
'{{ jobLevel }}',
{{ promotionValue }},
'{{ qualifications }}',
'{{ responsibilities }}',
'{{ postingRegion }}',
'{{ visibility }}',
'{{ jobStartTime }}',
'{{ jobEndTime }}',
'{{ postingPublishTime }}',
'{{ postingExpireTime }}',
'{{ processingOptions }}',
'{{ projectsId }}',
'{{ tenantsId }}'
RETURNING
name,
addresses,
applicationInfo,
company,
companyDisplayName,
compensationInfo,
customAttributes,
degreeTypes,
department,
derivedInfo,
description,
employmentTypes,
incentives,
jobBenefits,
jobEndTime,
jobLevel,
jobStartTime,
languageCode,
postingCreateTime,
postingExpireTime,
postingPublishTime,
postingRegion,
postingUpdateTime,
processingOptions,
promotionValue,
qualifications,
requisitionId,
responsibilities,
title,
visibility
;

Begins executing a batch create jobs operation.

INSERT INTO google.jobs.jobs (
data__jobs,
projectsId,
tenantsId
)
SELECT 
'{{ jobs }}',
'{{ projectsId }}',
'{{ tenantsId }}'
RETURNING
name,
done,
error,
metadata,
response
;

# Description fields are for documentation purposes
- name: jobs
  props:
    - name: projectsId
      value: string
      description: Required parameter for the jobs resource.
    - name: tenantsId
      value: string
      description: Required parameter for the jobs resource.
    - name: name
      value: string
      description: >
        Required during job update. The resource name for the job. This is generated by the service when a job is created. The format is "projects/{project_id}/tenants/{tenant_id}/jobs/{job_id}". For example, "projects/foo/tenants/bar/jobs/baz". Use of this field in job queries and API calls is preferred over the use of requisition_id since this value is unique.
        
    - name: company
      value: string
      description: >
        Required. The resource name of the company listing the job. The format is "projects/{project_id}/tenants/{tenant_id}/companies/{company_id}". For example, "projects/foo/tenants/bar/companies/baz".
        
    - name: requisitionId
      value: string
      description: >
        Required. The requisition ID, also referred to as the posting ID, is assigned by the client to identify a job. This field is intended to be used by clients for client identification and tracking of postings. A job isn't allowed to be created if there is another job with the same company, language_code and requisition_id. The maximum number of allowed characters is 255.
        
    - name: title
      value: string
      description: >
        Required. The title of the job, such as "Software Engineer" The maximum number of allowed characters is 500.
        
    - name: description
      value: string
      description: >
        Required. The description of the job, which typically includes a multi-paragraph description of the company and related information. Separate fields are provided on the job object for responsibilities, qualifications, and other job characteristics. Use of these separate job fields is recommended. This field accepts and sanitizes HTML input, and also accepts bold, italic, ordered list, and unordered list markup tags. The maximum number of allowed characters is 100,000.
        
    - name: addresses
      value: array
      description: >
        Strongly recommended for the best service experience. Location(s) where the employer is looking to hire for this job posting. Specifying the full street address(es) of the hiring location enables better API results, especially job searches by commute time. At most 50 locations are allowed for best search performance. If a job has more locations, it is suggested to split it into multiple jobs with unique requisition_ids (e.g. 'ReqA' becomes 'ReqA-1', 'ReqA-2', and so on.) as multiple jobs with the same company, language_code and requisition_id are not allowed. If the original requisition_id must be preserved, a custom field should be used for storage. It is also suggested to group the locations that close to each other in the same job for better search experience. Jobs with multiple addresses must have their addresses with the same LocationType to allow location filtering to work properly. (For example, a Job with addresses "1600 Amphitheatre Parkway, Mountain View, CA, USA" and "London, UK" may not have location filters applied correctly at search time since the first is a LocationType.STREET_ADDRESS and the second is a LocationType.LOCALITY.) If a job needs to have multiple addresses, it is suggested to split it into multiple jobs with same LocationTypes. The maximum number of allowed characters is 500.
        
    - name: applicationInfo
      value: object
      description: >
        Job application information.
        
    - name: jobBenefits
      value: array
      description: >
        The benefits included with the job.
        
    - name: compensationInfo
      value: object
      description: >
        Job compensation information (a.k.a. "pay rate") i.e., the compensation that will paid to the employee.
        
    - name: customAttributes
      value: object
      description: >
        A map of fields to hold both filterable and non-filterable custom job attributes that are not covered by the provided structured fields. The keys of the map are strings up to 64 bytes and must match the pattern: `a-zA-Z*`. For example, key0LikeThis or KEY_1_LIKE_THIS. At most 100 filterable and at most 100 unfilterable keys are supported. For filterable `string_values`, across all keys at most 200 values are allowed, with each string no more than 255 characters. For unfilterable `string_values`, the maximum total size of `string_values` across all keys is 50KB.
        
    - name: degreeTypes
      value: array
      description: >
        The desired education degrees for the job, such as Bachelors, Masters.
        
    - name: department
      value: string
      description: >
        The department or functional area within the company with the open position. The maximum number of allowed characters is 255.
        
    - name: employmentTypes
      value: array
      description: >
        The employment type(s) of a job, for example, full time or part time.
        
    - name: incentives
      value: string
      description: >
        A description of bonus, commission, and other compensation incentives associated with the job not including salary or pay. The maximum number of allowed characters is 10,000.
        
    - name: languageCode
      value: string
      description: >
        The language of the posting. This field is distinct from any requirements for fluency that are associated with the job. Language codes must be in BCP-47 format, such as "en-US" or "sr-Latn". For more information, see [Tags for Identifying Languages](https://tools.ietf.org/html/bcp47){: class="external" target="_blank" }. If this field is unspecified and Job.description is present, detected language code based on Job.description is assigned, otherwise defaults to 'en_US'.
        
    - name: jobLevel
      value: string
      description: >
        The experience level associated with the job, such as "Entry Level".
        
      valid_values: ['JOB_LEVEL_UNSPECIFIED', 'ENTRY_LEVEL', 'EXPERIENCED', 'MANAGER', 'DIRECTOR', 'EXECUTIVE']
    - name: promotionValue
      value: integer
      description: >
        A promotion value of the job, as determined by the client. The value determines the sort order of the jobs returned when searching for jobs using the featured jobs search call, with higher promotional values being returned first and ties being resolved by relevance sort. Only the jobs with a promotionValue >0 are returned in a FEATURED_JOB_SEARCH. Default value is 0, and negative values are treated as 0.
        
    - name: qualifications
      value: string
      description: >
        A description of the qualifications required to perform the job. The use of this field is recommended as an alternative to using the more general description field. This field accepts and sanitizes HTML input, and also accepts bold, italic, ordered list, and unordered list markup tags. The maximum number of allowed characters is 10,000.
        
    - name: responsibilities
      value: string
      description: >
        A description of job responsibilities. The use of this field is recommended as an alternative to using the more general description field. This field accepts and sanitizes HTML input, and also accepts bold, italic, ordered list, and unordered list markup tags. The maximum number of allowed characters is 10,000.
        
    - name: postingRegion
      value: string
      description: >
        The job PostingRegion (for example, state, country) throughout which the job is available. If this field is set, a LocationFilter in a search query within the job region finds this job posting if an exact location match isn't specified. If this field is set to PostingRegion.NATION or PostingRegion.ADMINISTRATIVE_AREA, setting job Job.addresses to the same location level as this field is strongly recommended.
        
      valid_values: ['POSTING_REGION_UNSPECIFIED', 'ADMINISTRATIVE_AREA', 'NATION', 'TELECOMMUTE']
    - name: visibility
      value: string
      description: >
        Deprecated. The job is only visible to the owner. The visibility of the job. Defaults to Visibility.ACCOUNT_ONLY if not specified.
        
      valid_values: ['VISIBILITY_UNSPECIFIED', 'ACCOUNT_ONLY', 'SHARED_WITH_GOOGLE', 'SHARED_WITH_PUBLIC']
    - name: jobStartTime
      value: string
      description: >
        The start timestamp of the job in UTC time zone. Typically this field is used for contracting engagements. Invalid timestamps are ignored.
        
    - name: jobEndTime
      value: string
      description: >
        The end timestamp of the job. Typically this field is used for contracting engagements. Invalid timestamps are ignored.
        
    - name: postingPublishTime
      value: string
      description: >
        The timestamp this job posting was most recently published. The default value is the time the request arrives at the server. Invalid timestamps are ignored.
        
    - name: postingExpireTime
      value: string
      description: >
        Strongly recommended for the best service experience. The expiration timestamp of the job. After this timestamp, the job is marked as expired, and it no longer appears in search results. The expired job can't be listed by the ListJobs API, but it can be retrieved with the GetJob API or updated with the UpdateJob API or deleted with the DeleteJob API. An expired job can be updated and opened again by using a future expiration timestamp. Updating an expired job fails if there is another existing open job with same company, language_code and requisition_id. The expired jobs are retained in our system for 90 days. However, the overall expired job count cannot exceed 3 times the maximum number of open jobs over previous 7 days. If this threshold is exceeded, expired jobs are cleaned out in order of earliest expire time. Expired jobs are no longer accessible after they are cleaned out. Invalid timestamps are ignored, and treated as expire time not provided. If the timestamp is before the instant request is made, the job is treated as expired immediately on creation. This kind of job can not be updated. And when creating a job with past timestamp, the posting_publish_time must be set before posting_expire_time. The purpose of this feature is to allow other objects, such as ApplicationInfo, to refer a job that didn't exist in the system prior to becoming expired. If you want to modify a job that was expired on creation, delete it and create a new one. If this value isn't provided at the time of job creation or is invalid, the job posting expires after 30 days from the job's creation time. For example, if the job was created on 2017/01/01 13:00AM UTC with an unspecified expiration date, the job expires after 2017/01/31 13:00AM UTC. If this value isn't provided on job update, it depends on the field masks set by UpdateJobRequest.update_mask. If the field masks include job_end_time, or the masks are empty meaning that every field is updated, the job posting expires after 30 days from the job's last update time. Otherwise the expiration date isn't updated.
        
    - name: processingOptions
      value: object
      description: >
        Options for job processing.
        
    - name: jobs
      value: array
      description: >
        Required. The jobs to be created. A maximum of 200 jobs can be created in a batch.
        

`UPDATE` examples

patch
batch_update

Updates specified job. Typically, updated contents become visible in search results within 10 seconds, but it may take up to 5 minutes.

UPDATE google.jobs.jobs
SET 
data__name = '{{ name }}',
data__company = '{{ company }}',
data__requisitionId = '{{ requisitionId }}',
data__title = '{{ title }}',
data__description = '{{ description }}',
data__addresses = '{{ addresses }}',
data__applicationInfo = '{{ applicationInfo }}',
data__jobBenefits = '{{ jobBenefits }}',
data__compensationInfo = '{{ compensationInfo }}',
data__customAttributes = '{{ customAttributes }}',
data__degreeTypes = '{{ degreeTypes }}',
data__department = '{{ department }}',
data__employmentTypes = '{{ employmentTypes }}',
data__incentives = '{{ incentives }}',
data__languageCode = '{{ languageCode }}',
data__jobLevel = '{{ jobLevel }}',
data__promotionValue = {{ promotionValue }},
data__qualifications = '{{ qualifications }}',
data__responsibilities = '{{ responsibilities }}',
data__postingRegion = '{{ postingRegion }}',
data__visibility = '{{ visibility }}',
data__jobStartTime = '{{ jobStartTime }}',
data__jobEndTime = '{{ jobEndTime }}',
data__postingPublishTime = '{{ postingPublishTime }}',
data__postingExpireTime = '{{ postingExpireTime }}',
data__processingOptions = '{{ processingOptions }}'
WHERE 
projectsId = '{{ projectsId }}' --required
AND tenantsId = '{{ tenantsId }}' --required
AND jobsId = '{{ jobsId }}' --required
AND updateMask = '{{ updateMask}}'
RETURNING
name,
addresses,
applicationInfo,
company,
companyDisplayName,
compensationInfo,
customAttributes,
degreeTypes,
department,
derivedInfo,
description,
employmentTypes,
incentives,
jobBenefits,
jobEndTime,
jobLevel,
jobStartTime,
languageCode,
postingCreateTime,
postingExpireTime,
postingPublishTime,
postingRegion,
postingUpdateTime,
processingOptions,
promotionValue,
qualifications,
requisitionId,
responsibilities,
title,
visibility;

Begins executing a batch update jobs operation.

UPDATE google.jobs.jobs
SET 
data__jobs = '{{ jobs }}',
data__updateMask = '{{ updateMask }}'
WHERE 
projectsId = '{{ projectsId }}' --required
AND tenantsId = '{{ tenantsId }}' --required
RETURNING
name,
done,
error,
metadata,
response;

`DELETE` examples

delete
batch_delete

Deletes the specified job. Typically, the job becomes unsearchable within 10 seconds, but it may take up to 5 minutes.

DELETE FROM google.jobs.jobs
WHERE projectsId = '{{ projectsId }}' --required
AND tenantsId = '{{ tenantsId }}' --required
AND jobsId = '{{ jobsId }}' --required;

Begins executing a batch delete jobs operation.

DELETE FROM google.jobs.jobs
WHERE projectsId = '{{ projectsId }}' --required
AND tenantsId = '{{ tenantsId }}' --required;

Lifecycle Methods

search
search_for_alert

Searches for jobs using the provided SearchJobsRequest. This call constrains the visibility of jobs present in the database, and only returns jobs that the caller has permission to search against.

EXEC google.jobs.jobs.search 
@projectsId='{{ projectsId }}' --required, 
@tenantsId='{{ tenantsId }}' --required 
@@json=
'{
"searchMode": "{{ searchMode }}", 
"requestMetadata": "{{ requestMetadata }}", 
"jobQuery": "{{ jobQuery }}", 
"enableBroadening": {{ enableBroadening }}, 
"histogramQueries": "{{ histogramQueries }}", 
"jobView": "{{ jobView }}", 
"offset": {{ offset }}, 
"maxPageSize": {{ maxPageSize }}, 
"pageToken": "{{ pageToken }}", 
"orderBy": "{{ orderBy }}", 
"diversificationLevel": "{{ diversificationLevel }}", 
"customRankingInfo": "{{ customRankingInfo }}", 
"disableKeywordMatch": {{ disableKeywordMatch }}, 
"keywordMatchMode": "{{ keywordMatchMode }}", 
"relevanceThreshold": "{{ relevanceThreshold }}"
}';

Searches for jobs using the provided SearchJobsRequest. This API call is intended for the use case of targeting passive job seekers (for example, job seekers who have signed up to receive email alerts about potential job opportunities), it has different algorithmic adjustments that are designed to specifically target passive job seekers. This call constrains the visibility of jobs present in the database, and only returns jobs the caller has permission to search against.

EXEC google.jobs.jobs.search_for_alert 
@projectsId='{{ projectsId }}' --required, 
@tenantsId='{{ tenantsId }}' --required 
@@json=
'{
"searchMode": "{{ searchMode }}", 
"requestMetadata": "{{ requestMetadata }}", 
"jobQuery": "{{ jobQuery }}", 
"enableBroadening": {{ enableBroadening }}, 
"histogramQueries": "{{ histogramQueries }}", 
"jobView": "{{ jobView }}", 
"offset": {{ offset }}, 
"maxPageSize": {{ maxPageSize }}, 
"pageToken": "{{ pageToken }}", 
"orderBy": "{{ orderBy }}", 
"diversificationLevel": "{{ diversificationLevel }}", 
"customRankingInfo": "{{ customRankingInfo }}", 
"disableKeywordMatch": {{ disableKeywordMatch }}, 
"keywordMatchMode": "{{ keywordMatchMode }}", 
"relevanceThreshold": "{{ relevanceThreshold }}"
}';

Overview​

Fields​

Methods​

Parameters​

SELECT examples​

INSERT examples​

UPDATE examples​

DELETE examples​

Lifecycle Methods​