Project Log Transaction ID

Use this web service to return the Project Log web service details including the Transaction ID for the use with the Project Log Image web service.

Connection Information

URL = https://<SPECTRUM-SERVER>:/projectLog/{companyCode}/{jobNumber}?category={category}&referenceNumber={referenceNumber}

Authentication: Basic Authentication, Enhanced Authentication

Supported methods: GET

Supported formats: JSON

Sample JSON Body

[
	{
		"Company_Code": "SP2",
		"Job_Number": "       450",
		"ProjectLogTran_Id": "71AFBD9D-454E-44A0-A254-3987815C39BB",
		"Category": "ISSUE     ",
		"Reference_Num": "         2",
		"Topic": "99-I am writing this memo to ... ",
		"Issue_Date": "May 4, 2012",
		"Resp_Req_Date": "May 5, 2012",
		"Answered_Date": "May 20, 2012",
		"Cost_Impact": " ",
		"Schedule_Impact": " ",
		"Status": "O",
		"Activity": "A",
		"Priority": "M",
		"Classification": "Issue",
		"Spec_Section": "?",
		"Phase": "",
		"Building": "          ",
		"Area": "          ",
		"Responsibility": "2-I am writing this memo to ...",
		"Reference": "3-I am writing this memo to ...",
		"Sent_via": "?    ",
		"Direction": " ",
		"Email_Date": "Jun 1, 2015",
		"Weather": "4-I am writing this memo to ...",
		"AM_Temperature": "?     ",
		"PM_Temperature": "?     ",
		"Precipitation_Amount": 0,
		"Wind": "?              ",
		"External_Ref1": "?",
		"External_Ref2": "?",
		"External_Link": "Y",
		"External_Id": "5-I am writing this memo to ...",
		"Authored_By": "6-I am writing this memo to ...",
		"Cost_Impact_Amount": 1234567890.12,
		"Sent_To_Submitter": "Jan 2, 2012",
		"Required_From_Submitter": "Jan 3, 2012",
		"Received_From_Submitter": "Jan 4, 2012",
		"Sent_To_Approver": "Jan 5, 2012",
		"Required_From_Approver": "Jan 6, 2012",
		"Received_From_Approver": "Jan 7, 2012",
		"Return_To_Submitter": "Jan 8, 2012",
		"Scheduled_Delivery": "Jan 9, 2012",
		"Actual_Delivery": "Jan 10, 2012",
		"Inspection": "Jan 11, 2012",
		"Re_Inspection": "Jan 12, 2012",
		"Scheduled_Complete": "Jan 13, 2012",
		"Signed_Off": "Jan 14, 2012",
		"Scheduled_Impact_Days": 0,
		"Log_Status": " ",
		"Subsection": " "
	}
]

Underlying File Maintenance

Prior to using the GET-Project Log Transaction ID web service, the following file maintenance areas must be completed:

System Administration > Installation > Job Cost
System Administration > Installation > Project Management > Project Log
System Administration > Installation > Project Management > Category Maintenance

Assumptions and Dependencies

The Web Service will return the Project Log web service details including the Transaction ID for the use with the PJ Project Log Image Web Service.
Parameter for get services will be Company Code, Job number, Category and Reference Number.
Any field with a NULL value in the table will not be returned in the web service.
The unique combination of the Company Code, Job number, and Category will be validated.

Field Descriptions

Use the table below for reference when using this service.

Note: The Authorization_ID and GUID elements are not shown on the Spectrum Excel Office Add-in templates for data entry points.


Excel	Element Name	Description	Req	Type	Max	Format	Validation
	Authorization_ID	Authorization ID to access the server	YES	Text	20		Data Exchange Installation Screen
	GUID	Unique reference number created by programming		Text	36		** See GUID definition
B	Company_Code	Company Code		Text	3	Can default from Authorization Id	Valid Company in Spectrum; defaults from the Authorization ID if not populated.
C	Job_Number	Job code	YES	Text	10		Valid Job in Spectrum
D	TransactionId	Project Log ID		Text	36	TransactionId is created within Spectrum when the project log is added. If defined, the record will be updated.	Validates to the Project Log entry.
E	Category	Category		Text	30		Validates to the Project Management Category Maintenance
F	Reference_Num	Number		Text	10	Reference_Num is created within Spectrum when the project log is added. ** If defined and the Company_Code, Job_Number and Category is unique the record will be updated otherwise creates a new entry.	Validates to the Project Log entry.
G	Topic	Topic		Text	250
H	Issued_Date	Issued date		Date	10	Enter as: MM/DD/CCYY (01/15/2023) If left blank it will use the current date.
I	Resp_Req_Date	Respond by		Date	10	Enter as: MM/DD/CCYY (01/15/2023)
J	Answered_Date	Answered		Date	10	Enter as: MM/DD/CCYY (01/15/2023)
K	Cost_Impact	Cost impact?		Text	1	(Y)es or (N)o or blank field
L	Schedule_Impact	Schedule impact?		Text	1	(Y)es or (N)o or blank field
M	Status	Closed?		Text	1	(O)pen or (C)losed
N	Activity	Activity flag?		Text	1	(A)cton needed, (I)nformation or (T)racking
O	Priority	Priority flag?		Text	1	(H)igh, (M)edium or (L)ow
P	Classification	Discipline		Text	50		Validates to the Project Management Classification Maintenance
Q	Spec_Section	Spec Section		Text	30
R	Phase	Phase		Text	20	No dashes	Validates to the Job Phase
S	Building	Building		Text	10		Validates to the Project Management Building / Area Maintenance
T	Area	Area		Text	10		Validates to the Project Management Building / Area Maintenance
U	Responsibility	Responsibility		Text	250
V	Reference	Reference		Text	250
W	Sent_via	Sent via		Text	50
X	Direction	Direction		Text	1	(I)nbound or (O)utbound or blank
Y	Email_Date	E-mail date		Date	10	Enter as: MM/DD/CCYY (01/15/2023)
Z	Weather	Weather		Text	250
AA	AM_Temperature	AM Temperature		Text	6
AB	PM_Temperature	PM Temperature		Text	6
AC	Precipitation_Amount	Precipitation Amount		Numeric	6	Positive number only. Enter as : xx.xxx
AD	Wind	Wind		Text	15
AE	External_Ref1	External ID		Text	30
AF	External_Ref2	Owner number		Text	30
AG	External_Link	Access to External Program?		Text	1	(Y)es or (N)o or blank field	**See Assumptions and Dependencies.
AH	External_Id	External Program's Web URL		Text	250	Used to open details using the web link logic in Spectrum.	**See Assumptions and Dependencies. If defined, then the External_Link = Y
AI	Authored_By	Authored by		Text	250
AJ	Cost_Impact_Amount	Cost impact amount		Numeric	14	Allows negatives; decimals OK
AK	Sent_To_Submitter	Sent to submitter		Date	10	Enter as: MM/DD/CCYY (01/15/2023)
AL	Required_From_Submitter	Required from submitter		Date	10	Enter as: MM/DD/CCYY (01/15/2023)
AM	Received_From_Submitter	Received from submitter		Date	10	Enter as: MM/DD/CCYY (01/15/2023)
AN	Sent_To_Approver	Sent to approver		Date	10	Enter as: MM/DD/CCYY (01/15/2023)
AO	Required_From_Approver	Required from approver		Date	10	Enter as: MM/DD/CCYY (01/15/2023)
AP	Received_From_Approver	Received from approver		Date	10	Enter as: MM/DD/CCYY (01/15/2023)
AQ	Returned_To_Submitter	Returned to submitter		Date	10	Enter as: MM/DD/CCYY (01/15/2023)
AR	Scheduled_Delivery	Scheduled delivery		Date	10	Enter as: MM/DD/CCYY (01/15/2023)
AS	Actual_Delivery	Actual delivery		Date	10	Enter as: MM/DD/CCYY (01/15/2023)
AT	Inspection	Inspection		Date	10	Enter as: MM/DD/CCYY (01/15/2023)
AU	Re_Inspection	Reinspection		Date	10	Enter as: MM/DD/CCYY (01/15/2023)
AV	Scheduled_Complete	Scheduled complete		Date	10	Enter as: MM/DD/CCYY (01/15/2023)
AW	Signed_Off	Signed off		Date	10	Enter as: MM/DD/CCYY (01/15/2023)
AX	Schedule_Impact_Days	Schedule Impact days		Numeric	4	Allows negatives; decimals OK
AY	Log_Status	Log Status		Text	30
AZ	Subsection	Subsection		Text	10

Welcome to Help for all Trimble Viewpoint products.