Paprika API – Create Job

Estimated reading: 4 minutes 217 views Contributors

Scopes Required

write:jobs

Linked User Privileges Required

Job Maintenance

URL

POST /api/v1/jobs/createJob

Compulsory Fields

Job Name
Client ID (SA_MN)
Fee Type
Business Unit ID (BU_MN)
Status

Examples

{
     "JO_JOB_TITLE": "Job title",
     "JO_SA_MN": 4567,
     "JO_FEE_TYPE": "TES1",
     "JO_BU_MN": 1,
     "JO_STATUS": "TEST"
}

Response

Success

{
     "status": true,
     "message": null,
     "result": {
          "JO_MN": 1234
     }
}

Failure

{
     "status": false,
     "message": "Client not found",
     "result": null,
     "console": "",
     "field": "JO_SA_MN",
     "error": "API_ERROR",
     "value": null,
     "table": "JOB_HEAD"
}

Fields

Field	Compulsory	Data Type	Notes
JO_JOB_TITLE	Yes	Character(45)
JO_SA_MN	Yes	Integer	Must link to a valid Client record
JO_FEE_TYPE	Yes	Character(4)	Must link to a valid Fee Type record
JO_BU_MN	Either JO_BU_MN or JO_BU_REF must be provided	Integer	Must link to a valid Business Unit record
JO_BU_REF	Either JO_BU_MN or JO_BU_REF must be provided	Character(10)	Must link to a valid Business Unit record
JO_STATUS	Yes	Character(4)	Must link to a valid Status record
JO_JOB_KEY	Yes if not autonumbered	Character(10)	Must be unique
JO_ANAL_CODE1	Yes (unless you have a “Blank” type)	Character(4)	Must link to a valid Analysis Code record, will default to Blank if not given
JO_ANAL_CODE2	Yes (unless you have a “Blank” type)	Character(4)	Must link to a valid Analysis Code record, will default to Blank if not given
JO_ANAL_CODE3	Yes (unless you have a “Blank” type)	Character(4)	Must link to a valid Analysis Code record, will default to Blank if not given
JO_XAC_CODE1	Yes (unless you have a “Blank” type)	Character(4)	Must link to a valid Analysis Code record, will default to Blank if not given
JO_XAC_CODE2	Yes (unless you have a “Blank” type)	Character(4)	Must link to a valid Analysis Code record, will default to Blank if not given
JO_XAC_CODE3	Yes (unless you have a “Blank” type)	Character(4)	Must link to a valid Analysis Code record, will default to Blank if not given
JO_XAC_CODE4	Yes (unless you have a “Blank” type)	Character(4)	Must link to a valid Analysis Code record, will default to Blank if not given
JO_XAC_CODE5	Yes (unless you have a “Blank” type)	Character(4)	Must link to a valid Analysis Code record, will default to Blank if not given
JO_COST_SCALE		Character(4)	Must link to a valid Cost Scale record, will default to the Client’s Cost Scale record if not given
JO_CHARGE_SCALE		Character(4)	Must link to a valid Charge Scale record, will default to the Client’s Charge Scale record if not given
JO_EXT_CHRG_SCALE		Character(4)	Must link to a valid Charge Scale record, will default to the Client’s External Charge Scale record if not given
JO_ES_CODE		Character(4)	Must link to a valid Expense Scale record, will default to the Client’s Expense Scale record if not given
JO_CONTACT_NAME		Character(30)	Will default to the Client’s Contact if not given
JO_LONG_NAME		Character(2000)	Will default to JO_JOB_TITLE if not given
JO_OPEN_DATE		Date	Will default to today if not given
JO_SP_MN		Integer	Must link to a valid Super Project record
JO_ULT_SA_MN		Integer	Must link to a valid Client record
JO_BRA_MN		Integer	Must link to a valid Brand record
JO_HR_CODE		Character(4)	Must link to a valid HR Job Type record
JO_ART_MN		Integer	Must link to a valid Artist record
JO_PROJECT_MANAGER		Character(10)	Must link to a valid Personnel record
JO_STAFF_1		Character(10)	Must link to a valid Personnel record
JO_STAFF_2		Character(10)	Must link to a valid Personnel record
JO_STAFF_3		Character(10)	Must link to a valid Personnel record
JO_GRP_CODE		Character(10)	Must link to a valid User Group record
JO_EXTRA_1		Character(30)
JO_EXTRA_2		Character(30)
JO_EXTRA_3		Character(30)
JO_NUMBER_1		Number(2dp)
JO_NUMBER_2		Number(2dp)
JO_NUMBER_3		Number(2dp)
JO_NUMBER_4		Number(2dp)
JO_TEXT_1		Character(2000)
JO_TEXT_2		Character(2000)
JO_TEXT_3		Character(2000)
JO_TEXT_4		Character(2000)
JO_DATE_1		Date
JO_DATE_2		Date
JO_DATE_3		Date
JO_DATE_4		Date
JO_PROBABILITY		Integer	Must be between 0 and 100 inclusive
JO_CONT_VAL		Number(2dp)
JO_PC_TOT_FEE		Number(2dp)
JO_QUOTED_FEE		Number(2dp)	Positive numbers only
JO_QUOTED_EXP
JO_SCHD_CMPLT
JO_CLOSED_TIM
JO_CLOSED_EXP
JO_TIMESHEET_INST
JO_CUST_REF
JO_CURRENT_TEXT
JO_ACTION_DATE
JO_ALERT_FLAGS
JO_JOB_BRIEF