Fact Sheets API

Fact sheets are used to store, adapt, arrange, and process data from various sources prior to, during, and after a sourcing event in CSO.

Fact fields define the data to be held, just like item fields or columns in an Excel work sheet. Each fact row should contain only one value for each fact field in order to be able to use the data efficiently. Fact sheets are used to enter data into the event, for instance historical volumes or other item specifications, supplier performance scores, lists of addresses and codes for plants, articles or services, postal codes, latitudes, etc. 

Use the Fact Sheets API's to create, update, or query the Fact Sheets Data. This includes specific endpoints to take action (create/update/delete) as well as data associated related to rows, fields.

The URL to access the API's is : https://<instance>.cso.coupahost.com/api/events/{event-id}/fact-sheets

See Integration Best Practices for more info.

Actions

Elements

These are the elements available for the Fact Sheets API

Examples

In this example, we queried for a Fact Sheets API.

https://<instance>.cso.coupahost.com/api/events/{event-id}/fact-sheets 

We did a GET to the URL below for a sample Event-id = 9219593444837772101 : 

htpss://<instance>.cso.coupacloud.com/api/events/9219593444837772101/fact-sheets

Fact Sheets GET Response

{
		"total": 4,
		"fact-sheets": [
				{
						"id": "9219593444824438589",
						"ordinal": 0,
						"type": "Ordinary",
						"name": "B_Supernova 2014 - Rd2 Analysis",
						"formula-name": "b_supernova_2014_rd2_analysis",
						"event-id": "9219593444837772101",
						"created-time": "2015-02-27T16:56:09.875+0000"
				},
				{
						"id": "9219593444824438592",
						"ordinal": 1,
						"type": "Ordinary",
						"name": "PD_Project details",
						"formula-name": "pd_project_details",
						"event-id": "9219593444837772101",
						"created-time": "2015-02-27T16:56:09.875+0000"
				},
				{
						"id": "9219601795978222763",
						"ordinal": 1,
						"type": "Reporting",
						"name": "Management Reporting",
						"formula-name": "management_reporting",
						"event-id": "9219593444837772101",
						"created-time": "2020-02-10T03:17:03.96+0000"
				},
				{
						"id": "9219601942217814052",
						"ordinal": 1,
						"type": "Reporting",
						"name": "Test All Event Status",
						"formula-name": "test_all_event_status",
						"event-id": "9219593444837772101",
						"description": "Test All Event Status",
						"created-time": "2020-09-09T10:30:07.376+0000"
				} 
	 ]
}

Create/Update/Delete

The following describes how you can use the Coupa API to perform actions on Fact Sheets.

Create

/api/events/:id/fact-sheets

The below payload creates new fact sheet on an event(9220538753252871154)

Payload: 
{
		"fact-sheets": [
				{
						"id": "9220538753431210838",
						"name": "demo-factsheet-new",
						"event-id": "9220538753252871154",
						"description": "testing demo fact sheet using API"
				}
		]
}

Response: 201
{
		"result": [
				{
						"type": "api.post.added",
						"description": "1 objects created."
				}
		],
		"added": 1,
		"fact-sheets": [
				{
						"id": "9220538753455571178"
				}
		]
}		

Update

/api/events/{event-id}/fact-sheets

The below payload updates a fact sheet(s).  

To update one or more Event at a time: 
Payload:
{
		"fact-sheets": [
				{
						"id": "9220538753461853110",
						"name": "demo-factsheet-newest",
						"formula-name": "demo_factsheet_newest",
						"description": "testing demo fact sheet using API with ordinal"
				}
		]
}

Response: 200 OK
{
		"result": [
				{
						"type": "api.put.updated",
						"description": "1 objects updated."
				}
		],
		"updated": 1
}

You can update only name/formula-name/description fields on a fact sheet.

Delete

/api/events/{event-id}/fact-sheets

The above API can be used to delete more than one fact sheet at a time. 

Payload:
{
		"fact-sheets": [
				{
						"id": "9220538753461853110"
				}
		]
}

Response: 200 OK
{
		"result": [
				{
						"type": "removedFactSheets",
						"description": "Removed the following fact sheets: demo-factsheet-newest"
				}
		],
		"deleted": 1
}

Successful requests will return HTTP 200 Response. The body of the response will include the created requisition. Unsuccessful requests will return HTTP 400 Bad Request. The body of the response will include validation errors formatted as XML.