[API-712] API Integration for Splunk application with simPro

[james]

Hi,
I am trying to integrate Splunk with simPro. While I make an API call to simPro, I am getting only a request ID.
Could anyone help me out, how to make an API call to fetch the data from simPro. We have several Open Jobs in simPro, as per our business requirement I have to pull all the data from simPro to Splunk, which are related to the Job and Task like, Name of Job and associated Tasks. Creation date, due date, Completed date, etc..

Thank you,
James Kurian

[Jupiter-Andrew]

Please post an example of your API call URL, what data you're expecting to retrieve, and what you actually are getting. Can't help you without that basic info.

[james]

Hi,

Thank you Andrew, for your response.
Somehow we manged to get the data however we have some issue with fields.
This is the api url i am calling is this https://.simprosuite.com/api/v1.0/companies/{c}/jobs/{job}/timelines/ the API reference is here http://developer.simprogroup.com/apidoc ... 4962cdec4a

The API response appears to be malformed as it has <BR /> tags in it which is html line break rather than the Json we are expecting according to the api reference, it is also missing the project due date (called start date in simpro see picture).

[{"Type":"Task","Message":"Issued task 249 - Tx Availability to Andrew<br \/>Issued task 251 - MS006 - Testing to Andrew<br \/>Issued task 250 - Site Integration to Andrew<br \/>Issued task 252 - Site On Air to Andrew<br \/>Issued task 247 - Tx Design to Andrew<br \/>Issued task 248 - Drake Booking to Andrew<br \/>Issued task 246 - Tx Modelling to Andrew<br \/>Issued task 245 - AAA Achievement to Andrew<br \/>Issued task 241 - Design Submit to Andrew<br \/>Issued task 243 - Property Planning to Andrew<br \/>Issued task 242 - Design Complete to Andrew<br \/>Issued task 244 - ACIF\/DA Planning to Andrew<br \/>Issued task 240 - Site Design Visit to Andrew","Staff":{"ID":17,"Name":"James Kurian","Type":"employee","TypeId":17},"Date":"2019-10-28 16:07:42+11"},{"Type":"General Message","Message":"Job created.","Staff":{"ID":17,"Name":"James Kurian","Type":"employee","TypeId":17},"Date":"2019-10-28 15:50:03.043106+11"},{"Type":"Task","Message":"Completed task 240 - Site Design Visit","Staff":{"ID":32,"Name":"Andrew","Type":"employee","TypeId":32},"Date":"2019-09-13 16:07:40"}

[Muqeet]

Hi James,

Job timelines is a list of brief job details or you can call them events. Timeline can have different type of messages (schedule, customer notes, purchase order, job card, invoice, task, etc).

There seems to be an issue with task within timelines endpoint. You should be able to see the list of task separately and not just separated by a line break. We are working on a fix as we speak.

Start date mentioned in the attachment can be retrieved from timeline Type 'General Message', or you can just get that from job endpoint's 'DateIssued' field. Similarly due date 'DueDate' can also be retrieved from job's endpoint.

In case you are referring to due date of task, that can be obtained from the job task endpoint. Please refer to the following documentation link.
http://developer.simprogroup.com/apidoc ... 52bb80d5d9

Thanks
Muqeet