This GET API can be used to pull contract metadata, milestones, and team members from the Quantum system in one call and post them into the ERP.
URL Format: https://<Instance>/leo-clm-v2-aggregator/api/v2/aggregator/GetAllContracts
Payload/Request | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
pageSize | Yes | String | Number of documents per page | Page Size should not exceed the value defined in the config CLM_GetAllContracts_Threshold |
pageNumber | Yes | String | Page Number | Page number starts with '1' |
Response | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
CLMDetails | Array | A List of contract documents | ||
errorMessage | String | It’s a string which shows any errors / validation messages |
CLMDetails | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
_id | String | |||
IsSourcingLineProcessed | Boolean | |||
isParentContractLinkagePresent | Boolean | |||
isPartialSave | Boolean | |||
isDocSaved | Boolean | |||
isMigrated | Boolean | |||
isLatestCopy | Boolean | |||
executedCounter | Integer | |||
liveCounter | Integer | |||
isAmendent | Boolean | |||
amendentStatus | Integer | |||
createdOn | Date/Time | |||
currentLiveDate | Date/Time | |||
cancelledOn | Date/Time | |||
latestExecutedOn | Date/Time | |||
expiredCounter | Integer | |||
documentType | String | |||
submittedOn | Date/Time | |||
reinstateDate | Date/Time | |||
modifiedBy | String | |||
revisedContractNumber | String | |||
modifiedOn | Date/Time | |||
initialLiveDate | Date/Time | |||
documentName | String | |||
closedOn | Date/Time | |||
reinstateBefore | Date/Time | |||
isReinstated | Boolean | |||
isLeoTprmEnabled | Boolean | |||
terminatedOn | Date/Time | |||
documentCode | String | |||
leoMasterRiskAssessmentId | String | |||
requestGuid | String | |||
masterRiskAssessmentId | Long Number | |||
documentNumber | String | |||
longDocumentCode | String | |||
referenceRootId | String | |||
leaseScheduleNumber | String | |||
isCatalogIntegrationEnabled | Boolean | |||
lineCount | Integer | |||
isLinesExists | Boolean | |||
signedOn | Date/Time | |||
executedOn | Date/Time | |||
approvedOn | Date/Time | |||
leaseContractNumber | String | |||
timeStamp | Date/Time | |||
isAttachmentVisible | Boolean | |||
initialSourceType | String | |||
initialSourceId | String | |||
isAuthor | Boolean | |||
isCoAuthor | Boolean | |||
isOwner | Boolean | |||
isBulkDocument | Boolean | |||
isConversionNeeded | Boolean | |||
primarySupplierName | String | |||
isApprover | Boolean | |||
isTeamMember | Boolean | |||
holdReason | String | |||
isReviewer | Boolean | |||
holdDate | Date/Time | |||
isSupplierPOC | Boolean | |||
signatoryType | String | |||
rebateCounter | Integer | |||
isModificationInProgress | Boolean | |||
isModificationCopy | Boolean | |||
modificationRevisionNumber | String | |||
modificationRevisedContractNumber | String | |||
signatureModeKey | String | |||
isNewFileAdded | Boolean | |||
isNewVersionCreated | Boolean | |||
copyLinesOngoing | Boolean | |||
isDeleted | Boolean | |||
documentStatusHistory | Object | |||
internalParties | Array | List of internal parties | ||
legalTerm | Object | |||
stage | Object | |||
review | Object | |||
utilizationDetailsList | Array | |||
orgEntities | Array | List of organization entities | ||
categories | Array | List of categories | ||
externalParties | Array | List of external Parties | ||
interfaceDetails | Object | |||
paymentFrequency | Object | |||
basicDetail | Object | |||
parentDocumentLinkInfo | Array | |||
documentLinks | Array | |||
stageHistory | Object | |||
flagcollection | Object | |||
ultimateParent | Object | |||
notesAndLinks | Array | |||
documentStatus | Object | |||
regions | Array | |||
contractConsumptionHeader | Object | |||
contractScore | Object | |||
defineAccess | Object | |||
workgroups | Array | |||
createdByUser | Object | |||
modifiedByUser | Object | |||
outboundToERP | Object | |||
customAttributes | Object | Domain specific custom attributes | ||
disposalFields | Object | |||
teamMembers | Array | List of Team members |
teamMembers | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
_id | String | |||
clientContactCode | String | |||
coAuthor | Boolean | |||
contactCode | Integer | |||
documentCode | String | |||
emailId | String | |||
firstName | String | |||
fullName | String | |||
isActive | Boolean | |||
isAttachmentVisible | Boolean | |||
isGroup | Boolean | |||
isSelected | Boolean | |||
lastName | String | |||
lineReviewer | Boolean | |||
parent_id | String | |||
queueId | String | |||
queueName | String | |||
reviewer | Boolean | |||
role | Object | |||
root_id | String | |||
termReviewer | Boolean | |||
userId | Integer | |||
viewer | Boolean | |||
action | String | |||
buyerPartnerName | String | |||
clmDetails_documentCode | String | |||
groupId | Integer | |||
groupName | String | |||
id | String | |||
isDeleted | Boolean | |||
teamId | String | |||
teamName | String | |||
group | Object | |||
address | Object |
role | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
culture | String | |||
version | String | |||
id | String | |||
name | String | |||
code | String |
group | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
id | String | |||
name | String | |||
code | String |
disposalFields | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
onHold |
| Boolean |
|
|
inactiveDate |
| Date/Time |
|
|
retentionInYears |
| String |
|
|
disposalDate |
| Date/Time |
|
|
comments |
| String |
|
|
disposalCountry |
| Object |
|
|
createdByUser, modifiedByUser | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
userId | Integer | |||
firstName | String | |||
lastName | String | |||
buyerPartnerName | String | |||
contactCode | Integer | |||
emailId | String | |||
isActive | Boolean | |||
fullName | String | |||
clientContactCode | String | |||
id | String | |||
fullNameAndEmailId | String | |||
isGroup | Boolean |
workgroups | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
code | String | |||
name | String | |||
isDefault | Boolean | |||
entityId | String | |||
childCount | String | |||
level | String | |||
isActive | Boolean | |||
ancestors | String | |||
parentCode | String | |||
displayName | String |
contractScore | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
clauseRiskScore | Decimal | |||
performanceScore | Decimal |
contractConsumptionHeader | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
contractAllocationValue | Decimal | |||
contractConsumptionValue | Decimal | |||
contractInvoicedValue | Decimal | |||
contractInvoicedQuantity | Decimal | |||
contractConsumptionQuantity | Decimal | |||
id | String | |||
availableAmount | Decimal | |||
contractAllocationValueInBaseCurrency | Decimal | |||
contractConsumptionValueInBaseCurrency | Decimal | |||
contractInvoicedValueInBaseCurrency | Decimal | |||
migratedInvoicedValue | Decimal | |||
contractCreditMemoValue | Decimal | |||
contractCreditMemoQuantity | Decimal | |||
contractCreditMemoValueInBaseCurrency | Decimal |
regions | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
code | String | |||
name | String | |||
id | Integer | |||
displayName | String | |||
level | Integer | |||
parentDetails | Array | |||
culture | String |
regions.parentDetails | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
code | String | |||
name | String | |||
level | Integer | |||
id | Integer |
notesAndLinks | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
type | Integer | |||
description | String | |||
createdOn | Date/Time | |||
modifiedOn | Date/Time | |||
sequenceNo | Integer | |||
id | String | |||
isEditable | Boolean | |||
name | String | |||
code | String | |||
isNotesAndLinksConfidential | Boolean |
documentStatusHistory, documentStatus | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
stateCode | String | |||
stateName | String | |||
culture | String | |||
version | String | |||
statusKey | String |
flagcollection | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
isAmendmentContract | Boolean | |||
flowCompleted | Boolean |
internalParties | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
signatories |
| Array | List of signatories |
|
name
|
| String |
|
|
id |
| String |
|
|
clientCode |
| String |
|
|
referredAs |
| Object |
|
|
attorney |
| Object |
|
|
signatories, contact, attorney, basicDetail.owner, basicDetail.author, basicDetail.contractSponsor | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
userId |
| Integer |
|
|
firstName
|
| String |
|
|
lastName |
| String |
|
|
clientCode |
| String |
|
|
contactCode |
| Integer |
|
|
emailId |
| String |
|
|
isActive |
| Boolean |
|
|
fullName |
| String |
|
|
clientContactCode |
| String |
|
|
address |
| Object |
|
|
address | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
smartAddressCode |
| String |
|
|
addressCode |
| String |
|
|
addressline1 |
| String |
|
|
addressline2 |
| String |
|
|
addressline3 |
| String |
|
|
city |
| String |
|
|
zipCode |
| String |
|
|
stateCode |
| String |
|
|
phoneNo1 |
| String |
|
|
extensionNo1 |
| String |
|
|
phoneNo2 |
| String |
|
|
extensionNo2 |
| String |
|
|
mobileNo |
| String |
|
|
faxNo |
| String |
|
|
emailAddress |
| String |
|
|
poBoxNumber |
| String |
|
|
isdCode |
| String |
|
|
country |
| Object |
|
|
country | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
countryId |
| Integer |
|
|
countryCode |
| String |
|
|
countryName |
| String |
|
|
defaultLanguageCode |
| String |
|
|
referredAs | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
id |
| String |
|
|
name |
| String |
|
|
legalTerm | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
isAutoRenew |
| Boolean |
|
|
aggregatedLinetotal |
| Decimal |
|
|
currencyConversionDate |
| Date/Time |
|
|
effectiveDate |
| Date/Time |
|
|
effectiveForInDays |
| Integer |
|
|
effectiveForInMonths |
| Integer |
|
|
isCoterminous |
| Boolean |
|
|
isPerpetual |
| Boolean |
|
|
originalExpiryDate |
| Date/Time |
|
|
renewelCounter |
| Integer |
|
|
renewelFrequency |
| Integer |
|
|
renewelTerm |
| Integer |
|
|
utilizedValue |
| Decimal |
|
|
baseCurrencyValue |
| Decimal |
|
|
initialLimit |
| Decimal |
|
|
initialValue |
| Decimal |
|
|
value |
| Decimal |
|
|
limit |
| Decimal |
|
|
originalValue |
| Decimal |
|
|
expiryTimeline |
| String |
|
|
expiryDate |
| Date/Time |
|
|
lineTotalAmount |
| Decimal |
|
|
noticePeriod |
| Integer |
|
|
effectivePeriod |
| Integer |
|
|
previousContractValue |
| Decimal |
|
|
originalContractValue |
| Decimal |
|
|
previousContractValueInBaseCurrency |
| Decimal |
|
|
contractValueDifference |
| Decimal |
|
|
contractValueDifferenceInPercentage |
| Decimal |
|
|
contractValueDifferenceAbsolute |
| Decimal |
|
|
autoTerminationDate |
| Date/Time |
|
|
originalEffectiveDate |
| Date/Time |
|
|
renewelTermType |
| Object |
|
|
paymentTerm |
| Object |
|
|
contractValue |
| Object |
|
|
currency |
| Object |
|
|
initialContractValue |
| Object |
|
|
initialCurrency |
| Object |
|
|
aggregatedLineTotalAmount |
| Object |
|
|
noticePeriodTerm |
| Object |
|
|
remainInEffect |
| Object |
|
|
effectiveDuration |
| Object |
|
|
contractLimit |
| Object |
|
|
contractBaseCurrency |
| Object |
|
|
renewelTermType, basicDetail.amendmentType, basicDetail.interfaceStatus, disposalCountry | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
code |
| String |
|
|
name |
| String |
|
|
culture |
| String |
|
|
version |
| String |
|
|
localeKey |
| String |
|
|
id |
| String |
|
|
paymentTerm | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
isDefault |
| Boolean |
|
|
paymentTermCode |
| String |
|
|
lob |
| String |
|
|
orgEntityDetailCode |
| String |
|
|
paymentTermName |
| String |
|
|
description |
| String |
|
|
dueDays |
| Integer |
|
|
discountPercentage |
| Integer |
|
|
discountDays |
| Integer |
|
|
markAsDefault |
| Boolean |
|
|
clientCode |
| String |
|
|
sourceSystem |
| String |
|
|
isActive |
| Boolean |
|
|
culture |
| String |
|
|
version |
| String |
|
|
id |
| String |
|
|
name |
| String |
|
|
code |
| String |
|
|
erpCodeMapping |
| Array |
|
|
customKeys |
| Array |
|
|
erpCodeMapping | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
code |
| String |
|
|
lobCode |
| String |
|
|
erpCode |
| String |
|
|
customKeys | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
key |
| String |
|
|
value |
| String |
|
|
contractValue, initialContractValue, contractLimit | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
fromCurrency |
| String |
|
|
conversionDate |
| Date/Time |
|
|
value |
| Decimal |
|
|
currencyValue |
| Decimal |
|
|
convertedValue |
| Decimal |
|
|
isInitialContractValue |
| Boolean |
|
|
percent |
| Decimal |
|
|
currency, initialCurrency, remainInEffect, effectiveDuration, contractBaseCurrency, interfaceStatus, partyType, contractGrouping, outboundToERP | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
code |
| String |
|
|
name |
| String |
|
|
noticePeriodTerm | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
noticePeriod |
| Integer |
|
|
noticePeriodDate |
| String |
|
|
stage, stageHistory | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
stateCode |
| String |
|
|
stateName |
| String |
|
|
culture |
| String |
|
|
version |
| String |
|
|
stageKey |
| String |
|
|
name |
| String |
|
|
code |
| String |
|
|
review | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
sentDate |
| Date/Time |
|
|
reviewedDate |
| Date/Time |
|
|
isActive |
| Boolean |
|
|
reviewers |
| Array | List of reviewers |
|
reviewers | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
firstName |
| String |
|
|
lastName |
| String |
|
|
emailId |
| String |
|
|
contactCode |
| Integer |
|
|
utilizationDetailsList | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
sourceDocumentnumber |
| String |
|
|
contractNumber |
| String |
|
|
utilizedValue |
| Integer |
|
|
sourceDocumentCurrency |
| String |
|
|
id |
| String |
|
|
orgEntities | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
entityCode |
| String |
|
|
displayName |
| String |
|
|
entityName |
| String |
|
|
entityId |
| String |
|
|
entityDetailCode |
| String |
|
|
id |
| String |
|
|
lobCode |
| String |
|
|
entityType |
| String |
|
|
parentEntity |
| String |
|
|
parentEntityCode |
| String |
|
|
parentDetails |
| Array |
|
|
orgEntities.parentDetails | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
entityCode |
| String |
|
|
entityName |
| String |
|
|
level |
| Integer |
|
|
entityDetailCode |
| Integer |
|
|
categories | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
clientCode |
| String |
|
|
name |
| String |
|
|
id |
| Decimal |
|
|
displayName |
| String |
|
|
level |
| Decimal |
|
|
parentDetails |
| Array |
|
|
categories.parentDetails | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
id |
| Integer |
|
|
name |
| String |
|
|
level |
| Integer |
|
|
externalParties | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
signatories |
| Array | List of signatories |
|
name |
| String |
|
|
id |
| String |
|
|
clientPartnerCode |
| String |
|
|
referredAs |
| Object |
|
|
contact |
| Object |
|
|
doingBusinessAs |
| String |
|
|
smartPartnerCode |
| Integer |
|
|
supplierCodes |
| Array |
|
|
partyType |
| Array |
|
|
supplierLocation |
| Array |
|
|
isPrimary |
| Boolean |
|
|
supplierCodes | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
name |
| String |
|
|
sourceIdentificationNo |
| String |
|
|
code |
| Integer |
|
|
interfaceComments |
| String |
|
|
interfaceStatus |
| Object |
|
|
supplierLocation | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
clientLocationCode |
| String |
|
|
leoLocationId |
| String |
|
|
locationCode |
| String |
|
|
locationName |
| String |
|
|
locationId |
| Integer |
|
|
orderingLocationAddress |
| String |
|
|
partyName |
| String |
|
|
address |
| Object |
|
|
interfaceDetails | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
errorDetails |
| String |
|
|
sourceSystemValue |
| String |
|
|
sourceSystemName |
| String |
|
|
errorCode |
| String |
|
|
outBoundStatus |
| Object |
|
|
documentNumber |
| String |
|
|
outBoundStatus | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
culture |
| String |
|
|
version |
| String |
|
|
id |
| String |
|
|
name |
| String |
|
|
localeKey |
| String |
|
|
code |
| String |
|
|
paymentFrequency | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
id |
| Integer |
|
|
name |
| String |
|
|
basicDetail | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
description |
| String |
|
|
signedOn |
| Date/Time |
|
|
executedOn |
| Date/Time |
|
|
mode |
| Integer |
|
|
modeName |
| String |
|
|
submittedOn |
| Date/Time |
|
|
closedOn |
| Date/Time |
|
|
sourceType |
| String |
|
|
sourceDocumentId |
| String |
|
|
approvedOn |
| Date/Time |
|
|
isConfidential |
| Boolean |
|
|
isGlobal |
| Boolean |
|
|
isTemplate |
| Boolean |
|
|
isArchived |
| Boolean |
|
|
revisionNo |
| String |
|
|
oldParentDocumentCode |
| String |
|
|
comments |
| String |
|
|
executionCycleTimeInMins |
| Integer |
|
|
contractMode |
| String |
|
|
isTransactable |
| Boolean |
|
|
owner |
| Object |
|
|
author |
| Object |
|
|
contractSponsor |
| Object |
|
|
parentDocument |
| Object |
|
|
approvers |
| Array |
|
|
operationReason |
| Array |
|
|
amendmentType |
| Object |
|
|
contractSubType |
| Object |
|
|
contractType |
| Object |
|
|
interfaceStatus |
| Object |
|
|
operationReasonObject |
| Object |
|
|
terminationReason |
| Object |
|
|
parentDocument, ultimateParent | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
documentCode |
| String |
|
|
documentName |
| String |
|
|
documentNumber |
| String |
|
|
revisedContractNumber |
| String |
|
|
approvers | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
contactCode |
| Integer |
|
|
isApproved |
| Boolean |
|
|
operationReason, terminationReason | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
reason |
| String |
|
|
comments |
| String |
|
|
id |
| Integer |
|
|
type |
| Integer |
|
|
createdDate |
| Date/Time |
|
|
code |
| Integer |
|
|
contractSubType | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
code |
| String |
|
|
name |
| String |
|
|
culture |
| String |
|
|
version |
| String |
|
|
lineType |
| String |
|
|
id |
| String |
|
|
contractTypeId |
| String |
|
|
subContractTypeCode |
| String |
|
|
isDefault |
| Boolean |
|
|
contractType | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
code |
| String |
|
|
name |
| String |
|
|
culture |
| String |
|
|
version |
| String |
|
|
contractTypeCode |
| String |
|
|
id |
| String |
|
|
docNumberGenerationKey |
| String |
|
|
contractGrouping |
| Array |
|
|
operationReasonObject | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
code |
| String |
|
|
name |
| String |
|
|
codeType |
| String |
|
|
parentDocumentLinkInfo | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
documentCode |
| String |
|
|
documentId |
| String |
|
|
documentLinkType |
| String |
|
|
id |
| String |
|
|
documentType |
| String |
|
|
documentNumber |
| String |
|
|
documentLinks | ||||
Property | Required? | Data type | Description | Validations / Exceptions |
id |
| String |
|
|
dateCreated |
| String |
|
|
linkedDocumentCode |
| String |
|
|
linkedDocumentName |
| String |
|
|
linkedDocumentNumber |
| String |
|
|
documentUrl |
| String |
|
|
relationType |
| Integer |
|
|
relationTypeId |
| Integer |
|
|
appId |
| Integer |
|
|
statusCode |
| String |
|
|
statusName |
| String |
|
|
bpc |
| Integer |
|
|