GetRFxOutbound (Get)

Overview

This Get API is used to get the RFx outbound data.

URL Format : https://<Instanaces>/leo-rfxoutboundv2-api/api/v1/Interface/GetRFxOutbound

Request

 https://<Instanaces>/leo-rfxoutboundv2-api/api/v1/Interface/GetRFxOutbound

Response
{
    "eventType": "Request For Proposal",
    "eventCurrency": "AUD",
    "eventValue": "1234",
    "documentName": "SRF-RFx",
    "documentNumber": "RFX0002872",
    "documentDescription": "Request",
    "creationDateTime": "07/28/2023 06:16:35",
    "documentCreator": "7002220104000005",
    "documentClientContactCode": "CC-2023.000253",
    "documentCreatorUserName": "RFxV2Buyer1",
    "documentCreatorFullName": "RFxV2Buyer1 1",
    "category": [
        ""
    ],
    "region": [
        null
    ],
    "attachments": [
        {
            "name": "RFX0002854 - Pricesheet (4).xlsx",
            "isVisibleToSupplier": false,
            "classificationType": {},
            "createdBy": "RFxV2Buyer1 1",
            "createdOn": "2023-07-28T06:16:38",
            "fileSize": "42.118 KB",
            "sasUri": "https://static-leoqc.gep.com/nexxeqcdirectdatastorage/buyerpartnercode/70022201/1676029207/Attachments/RFX0002854%20-%20Pricesheet%20%284%29_40ae08d1-6dd0-4d84-b944-9707a797aef6.xlsx?sv=2020-08-04&st=2023-07-28T11%3A06%3A11Z&se=2023-07-28T11%3A51%3A11Z&sr=b&sp=r&rscc=no-cache%2C+no-store%2C+must-revalidate&rscd=attachment%3B+filename%3Dbuyerpartnercode%252f70022201%252f1676029207%252fAttachments%252fRFX0002854+-+Pricesheet+(4)_40ae08d1-6dd0-4d84-b944-9707a797aef6.xlsx&sig=tODTEGc68tItyeTnfOHZjQOdykchDQ193SAETi1W6PU%3D"
        },
        {
            "name": "RFX0002859 - Questionnaires (2) (1).xlsx",
            "isVisibleToSupplier": false,
            "classificationType": {},
            "createdBy": "RFxV2Buyer1 1",
            "createdOn": "2023-07-28T06:16:38",
            "fileSize": "28.790 KB",
            "sasUri": "https://static-leoqc.gep.com/nexxeqcdirectdatastorage/buyerpartnercode/70022201/1676029207/Attachments/RFX0002859%20-%20Questionnaires%20%282%29%20%281%29_213d7798-b913-4f84-8fcc-9df5f3c02238.xlsx?sv=2020-08-04&st=2023-07-28T11%3A06%3A11Z&se=2023-07-28T11%3A51%3A11Z&sr=b&sp=r&rscc=no-cache%2C+no-store%2C+must-revalidate&rscd=attachment%3B+filename%3Dbuyerpartnercode%252f70022201%252f1676029207%252fAttachments%252fRFX0002859+-+Questionnaires+(2)+(1)_213d7798-b913-4f84-8fcc-9df5f3c02238.xlsx&sig=73Ivfe0vvN5365iulJciY04%2BL%2Bmbhyuqj72AmsxWzUA%3D"
        },
        {
            "name": "RFX0002859 (1).xlsx",
            "isVisibleToSupplier": false,
            "classificationType": {},
            "createdBy": "RFxV2Buyer1 1",
            "createdOn": "2023-07-28T06:16:38",
            "fileSize": "70.031 KB",
            "sasUri": "https://static-leoqc.gep.com/nexxeqcdirectdatastorage/buyerpartnercode/70022201/1676029207/Attachments/RFX0002859%20%281%29_1a99a1c7-fd10-46cc-8630-a493bff61fec.xlsx?sv=2020-08-04&st=2023-07-28T11%3A06%3A11Z&se=2023-07-28T11%3A51%3A11Z&sr=b&sp=r&rscc=no-cache%2C+no-store%2C+must-revalidate&rscd=attachment%3B+filename%3Dbuyerpartnercode%252f70022201%252f1676029207%252fAttachments%252fRFX0002859+(1)_1a99a1c7-fd10-46cc-8630-a493bff61fec.xlsx&sig=%2BGjIgtbAaiTcvp067b7RiMXH60XY19EUdjGhXXWBeYE%3D"
        },
        {
            "name": "RFX0002859.xlsx",
            "isVisibleToSupplier": false,
            "classificationType": {},
            "createdBy": "RFxV2Buyer1 1",
            "createdOn": "2023-07-28T06:16:38",
            "fileSize": "70.108 KB",
            "sasUri": "https://static-leoqc.gep.com/nexxeqcdirectdatastorage/buyerpartnercode/70022201/1676029207/Attachments/RFX0002859_1f258508-cd2d-43d4-9628-0b25f250a862.xlsx?sv=2020-08-04&st=2023-07-28T11%3A06%3A11Z&se=2023-07-28T11%3A51%3A11Z&sr=b&sp=r&rscc=no-cache%2C+no-store%2C+must-revalidate&rscd=attachment%3B+filename%3Dbuyerpartnercode%252f70022201%252f1676029207%252fAttachments%252fRFX0002859_1f258508-cd2d-43d4-9628-0b25f250a862.xlsx&sig=J0U2sAKQHvs7aZZobFodrSANQyxWG75s8C4mrsK4kCE%3D"
        }
    ],
    "documentBU": [
        {
            "entityCode": "BU2",
            "entityType": "BusinessUnit",
            "isDefault": false,
            "LOBEntityCode": null
        }
    ],
    "linkedDocumentHierarchy": {
        "documentInfo": {
            "documentName": "SRF-RFx",
            "documentNumber": "RFX0002872"
        }
    },
    "customFields": [],
    "documentStatus": "Awarded",
    "eventTimeline": [
        {
            "Response": {
                "name": "Response Timeline",
                "startDate": "2023-07-04T04:00:00Z",
                "endDate": "2023-07-10T03:59:00Z",
                "visibleToSupplier": true
            }
        },
        {
            "Evaluation": {
                "name": "Evaluation Timeline",
                "startDate": "2023-07-10T04:00:00Z",
                "endDate": "2023-07-13T03:59:00Z",
                "visibleToSupplier": false
            }
        }
    ],
    "suppliers": [
        {
            "name": "qcTest2LeoSMB",
            "clientSupplierCode": null,
            "primaryRespondant": "kunal.kulkarni@gep.com",
            "shortlistedForFeedback": true,
            "supplierContacts": [
                {
                    "clientContactCode": 53885304000002,
                    "isPrimary": false,
                    "roleId": "1"
                }
            ],
            "responseCompletionStatus": "Awarded",
            "participationStatus": "Awarded",
            "partnerCode": 538853,
            "profileStatus": null,
            "sourceSystemInformation": {
                "name": "client supplier code",
                "sourceIdentificationNo": null
            }
        }
    ],
    "documentSupplierDetails": {
        "totalSupplierCount": 3,
        "invitedSupplierCount": 3,
        "guidelinesAcceptedSupplierCount": 2,
        "participationConfirmedSupplierCount": 2,
        "participationDeclinedSupplierCount": 0,
        "responseSubmittedSupplierCount": 0,
        "responseWithdrawnSupplierCount": 0,
        "awardedSupplierCount": 1,
        "nonAwardedSupplierCount": 1,
        "shortlistedSupplierCount": 1
    },
    "teamMembers": [
        {
            "firstName": "RFxV2Buyer1",
            "lastName": "1",
            "clientContactCode": "CC-2023.000253",
            "emailAddress": "Ashish.ranjan@gep.com",
            "groupId": "0",
            "groupName": "",
            "invitationStatus": "Invited",
            "evaluationAccess": "Complete",
            "coAuthoringAccess": "Complete",
            "isApprover": false
        },
        {
            "firstName": "SMB",
            "lastName": "Buyer1",
            "clientContactCode": "CC-2023.000275",
            "emailAddress": "Ashish.ranjan@gep.com",
            "groupId": "0",
            "groupName": "",
            "invitationStatus": "Invited",
            "evaluationAccess": "Complete",
            "coAuthoringAccess": "Neutral",
            "isApprover": false
        }
    ],
    "pricesheets": [
        {
            "priceSheetName": "SRF Material Price Sheet",
            "description": "",
            "priceSheetType": "Material",
            "createdBy": "CC-2023.000253",
            "lastModifiedBy": "CC-2023.000253",
            "columns": [
                {
                    "name": "Item name",
                    "type": "Text",
                    "mandatory": true,
                    "visibleToSupplier": true,
                    "forSupplierResponse": false,
                    "dropDownType": "",
                    "dropDownValue": "",
                    "isMandatoryEnabled": true,
                    "isAllowSupplierInputEnabled": true,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 0.0,
                    "isAutoSum": false
                },
                {
                    "name": "Item number",
                    "type": "Text",
                    "mandatory": true,
                    "visibleToSupplier": true,
                    "forSupplierResponse": false,
                    "dropDownType": "",
                    "dropDownValue": "",
                    "isMandatoryEnabled": true,
                    "isAllowSupplierInputEnabled": true,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 0.0,
                    "isAutoSum": false
                },
                {
                    "name": "Volume",
                    "type": "Numeric",
                    "mandatory": true,
                    "visibleToSupplier": true,
                    "forSupplierResponse": false,
                    "dropDownType": "",
                    "dropDownValue": "",
                    "isMandatoryEnabled": true,
                    "isAllowSupplierInputEnabled": true,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 0.0,
                    "isAutoSum": false
                },
                {
                    "name": "Unit",
                    "type": "Drop Down",
                    "mandatory": true,
                    "visibleToSupplier": true,
                    "forSupplierResponse": false,
                    "dropDownType": "",
                    "dropDownValue": "",
                    "isMandatoryEnabled": true,
                    "isAllowSupplierInputEnabled": true,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 0.0,
                    "isAutoSum": false
                },
                {
                    "name": "Baseline price per unit",
                    "type": "Currency",
                    "mandatory": true,
                    "visibleToSupplier": false,
                    "forSupplierResponse": false,
                    "dropDownType": "",
                    "dropDownValue": "",
                    "isMandatoryEnabled": true,
                    "isAllowSupplierInputEnabled": true,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 2.0,
                    "isAutoSum": false
                },
                {
                    "name": "Total baseline price",
                    "type": "Computed",
                    "mandatory": true,
                    "visibleToSupplier": false,
                    "forSupplierResponse": false,
                    "dropDownType": "",
                    "dropDownValue": "",
                    "isMandatoryEnabled": false,
                    "isAllowSupplierInputEnabled": false,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 2.0,
                    "isAutoSum": true
                },
                {
                    "name": "Price per unit",
                    "type": "Currency",
                    "mandatory": true,
                    "visibleToSupplier": true,
                    "forSupplierResponse": true,
                    "dropDownType": "",
                    "dropDownValue": "",
                    "isMandatoryEnabled": true,
                    "isAllowSupplierInputEnabled": true,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 2.0,
                    "isAutoSum": false
                },
                {
                    "name": "Total price",
                    "type": "Computed",
                    "mandatory": false,
                    "visibleToSupplier": true,
                    "forSupplierResponse": false,
                    "dropDownType": "",
                    "dropDownValue": "",
                    "isMandatoryEnabled": false,
                    "isAllowSupplierInputEnabled": false,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 2.0,
                    "isAutoSum": true
                },
                {
                    "name": "Revision",
                    "type": "Text",
                    "mandatory": false,
                    "visibleToSupplier": false,
                    "forSupplierResponse": false,
                    "dropDownType": null,
                    "dropDownValue": null,
                    "isMandatoryEnabled": true,
                    "isAllowSupplierInputEnabled": true,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 0.0,
                    "isAutoSum": false
                },
                {
                    "name": "Version",
                    "type": "Text",
                    "mandatory": false,
                    "visibleToSupplier": false,
                    "forSupplierResponse": false,
                    "dropDownType": null,
                    "dropDownValue": null,
                    "isMandatoryEnabled": true,
                    "isAllowSupplierInputEnabled": true,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 0.0,
                    "isAutoSum": false
                },
                {
                    "name": "Need by Date",
                    "type": "Date",
                    "mandatory": false,
                    "visibleToSupplier": false,
                    "forSupplierResponse": false,
                    "dropDownType": null,
                    "dropDownValue": null,
                    "isMandatoryEnabled": true,
                    "isAllowSupplierInputEnabled": true,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 0.0,
                    "isAutoSum": false
                }
            ],
            "rows": [
                {
                    "rowNumber": 1,
                    "data": [
                        {
                            "columnName": "Item name",
                            "columnValue": "IN15"
                        },
                        {
                            "columnName": "Item number",
                            "columnValue": "IN13"
                        },
                        {
                            "columnName": "Revision",
                            "columnValue": ""
                        },
                        {
                            "columnName": "Version",
                            "columnValue": ""
                        },
                        {
                            "columnName": "Volume",
                            "columnValue": 13
                        },
                        {
                            "columnName": "Unit",
                            "columnValue": "14 : Shot"
                        },
                        {
                            "columnName": "Need by Date",
                            "columnValue": ""
                        },
                        {
                            "columnName": "Baseline price per unit",
                            "columnValue": 45
                        },
                        {
                            "columnName": "Total baseline price",
                            "columnValue": 585.0
                        },
                        {
                            "columnName": "Price per unit",
                            "columnValue": 145
                        },
                        {
                            "columnName": "Total price",
                            "columnValue": 1885.0
                        }
                    ]
                },
                {
                    "rowNumber": 2,
                    "data": [
                        {
                            "columnName": "Item name",
                            "columnValue": "IN14"
                        },
                        {
                            "columnName": "Item number",
                            "columnValue": "IN14"
                        },
                        {
                            "columnName": "Revision",
                            "columnValue": ""
                        },
                        {
                            "columnName": "Version",
                            "columnValue": ""
                        },
                        {
                            "columnName": "Volume",
                            "columnValue": 14
                        },
                        {
                            "columnName": "Unit",
                            "columnValue": "13 : Ration"
                        },
                        {
                            "columnName": "Need by Date",
                            "columnValue": ""
                        },
                        {
                            "columnName": "Baseline price per unit",
                            "columnValue": 67.9
                        },
                        {
                            "columnName": "Total baseline price",
                            "columnValue": 950.6
                        },
                        {
                            "columnName": "Price per unit",
                            "columnValue": 67
                        },
                        {
                            "columnName": "Total price",
                            "columnValue": 938.0
                        }
                    ]
                }
            ]
        },
        {
            "priceSheetName": "PS_001",
            "description": null,
            "priceSheetType": "Material",
            "createdBy": "CC-2023.000253",
            "lastModifiedBy": "CC-2023.000253",
            "columns": [
                {
                    "name": "Volume",
                    "type": "Numeric",
                    "mandatory": true,
                    "visibleToSupplier": true,
                    "forSupplierResponse": false,
                    "dropDownType": "",
                    "dropDownValue": "",
                    "isMandatoryEnabled": true,
                    "isAllowSupplierInputEnabled": true,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 0.0,
                    "isAutoSum": false
                },
                {
                    "name": "Unit",
                    "type": "Drop Down",
                    "mandatory": true,
                    "visibleToSupplier": true,
                    "forSupplierResponse": false,
                    "dropDownType": "",
                    "dropDownValue": "",
                    "isMandatoryEnabled": true,
                    "isAllowSupplierInputEnabled": true,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 0.0,
                    "isAutoSum": false
                },
                {
                    "name": "Baseline price per unit",
                    "type": "Currency",
                    "mandatory": true,
                    "visibleToSupplier": false,
                    "forSupplierResponse": false,
                    "dropDownType": "",
                    "dropDownValue": "",
                    "isMandatoryEnabled": true,
                    "isAllowSupplierInputEnabled": true,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 2.0,
                    "isAutoSum": false
                },
                {
                    "name": "Total baseline price",
                    "type": "Computed",
                    "mandatory": true,
                    "visibleToSupplier": false,
                    "forSupplierResponse": false,
                    "dropDownType": "",
                    "dropDownValue": "",
                    "isMandatoryEnabled": false,
                    "isAllowSupplierInputEnabled": false,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 2.0,
                    "isAutoSum": true
                },
                {
                    "name": "Price per unit",
                    "type": "Currency",
                    "mandatory": true,
                    "visibleToSupplier": true,
                    "forSupplierResponse": true,
                    "dropDownType": "",
                    "dropDownValue": "",
                    "isMandatoryEnabled": true,
                    "isAllowSupplierInputEnabled": true,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 2.0,
                    "isAutoSum": false
                },
                {
                    "name": "Total price",
                    "type": "Computed",
                    "mandatory": false,
                    "visibleToSupplier": true,
                    "forSupplierResponse": false,
                    "dropDownType": "",
                    "dropDownValue": "",
                    "isMandatoryEnabled": false,
                    "isAllowSupplierInputEnabled": false,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 2.0,
                    "isAutoSum": true
                },
                {
                    "name": "Column 1",
                    "type": "Computed",
                    "mandatory": false,
                    "visibleToSupplier": false,
                    "forSupplierResponse": false,
                    "dropDownType": null,
                    "dropDownValue": null,
                    "isMandatoryEnabled": false,
                    "isAllowSupplierInputEnabled": false,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 0.0,
                    "isAutoSum": false
                },
                {
                    "name": "Column 2",
                    "type": "Currency",
                    "mandatory": false,
                    "visibleToSupplier": true,
                    "forSupplierResponse": true,
                    "dropDownType": "",
                    "dropDownValue": "",
                    "isMandatoryEnabled": true,
                    "isAllowSupplierInputEnabled": true,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 2.0,
                    "isAutoSum": false
                },
                {
                    "name": "Column 3",
                    "type": "Computed",
                    "mandatory": false,
                    "visibleToSupplier": false,
                    "forSupplierResponse": false,
                    "dropDownType": null,
                    "dropDownValue": null,
                    "isMandatoryEnabled": false,
                    "isAllowSupplierInputEnabled": false,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 0.0,
                    "isAutoSum": false
                }
            ],
            "rows": [
                {
                    "rowNumber": 1,
                    "data": [
                        {
                            "columnName": null,
                            "columnValue": ""
                        },
                        {
                            "columnName": "Volume",
                            "columnValue": 13.0
                        },
                        {
                            "columnName": "Unit",
                            "columnValue": "14 : Shot"
                        },
                        {
                            "columnName": "Baseline price per unit",
                            "columnValue": 67.0
                        },
                        {
                            "columnName": "Total baseline price",
                            "columnValue": 871.0
                        },
                        {
                            "columnName": "Price per unit",
                            "columnValue": 134
                        },
                        {
                            "columnName": "Total price",
                            "columnValue": 1742.0
                        },
                        {
                            "columnName": "Column 1",
                            "columnValue": 1876.0
                        },
                        {
                            "columnName": "Column 2",
                            "columnValue": 544.8
                        },
                        {
                            "columnName": "Column 3",
                            "columnValue": 2420.8
                        }
                    ]
                },
                {
                    "rowNumber": 2,
                    "data": [
                        {
                            "columnName": null,
                            "columnValue": ""
                        },
                        {
                            "columnName": "Volume",
                            "columnValue": 14.0
                        },
                        {
                            "columnName": "Unit",
                            "columnValue": "14 : Shot"
                        },
                        {
                            "columnName": "Baseline price per unit",
                            "columnValue": 8.9
                        },
                        {
                            "columnName": "Total baseline price",
                            "columnValue": 124.6
                        },
                        {
                            "columnName": "Price per unit",
                            "columnValue": 88
                        },
                        {
                            "columnName": "Total price",
                            "columnValue": 1232.0
                        },
                        {
                            "columnName": "Column 1",
                            "columnValue": 1320.0
                        },
                        {
                            "columnName": "Column 2",
                            "columnValue": 21
                        },
                        {
                            "columnName": "Column 3",
                            "columnValue": 1341.0
                        }
                    ]
                }
            ]
        },
        {
            "priceSheetName": "PS_002",
            "description": "<p>Type</p>",
            "priceSheetType": "Material",
            "createdBy": "CC-2023.000253",
            "lastModifiedBy": "CC-2023.000253",
            "columns": [
                {
                    "name": "Volume",
                    "type": "Numeric",
                    "mandatory": true,
                    "visibleToSupplier": true,
                    "forSupplierResponse": false,
                    "dropDownType": "",
                    "dropDownValue": "",
                    "isMandatoryEnabled": true,
                    "isAllowSupplierInputEnabled": true,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 0.0,
                    "isAutoSum": false
                },
                {
                    "name": "Unit",
                    "type": "Drop Down",
                    "mandatory": true,
                    "visibleToSupplier": true,
                    "forSupplierResponse": false,
                    "dropDownType": "",
                    "dropDownValue": "",
                    "isMandatoryEnabled": true,
                    "isAllowSupplierInputEnabled": true,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 0.0,
                    "isAutoSum": false
                },
                {
                    "name": "Baseline price per unit",
                    "type": "Currency",
                    "mandatory": true,
                    "visibleToSupplier": false,
                    "forSupplierResponse": false,
                    "dropDownType": "",
                    "dropDownValue": "",
                    "isMandatoryEnabled": true,
                    "isAllowSupplierInputEnabled": true,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 2.0,
                    "isAutoSum": false
                },
                {
                    "name": "Total baseline price",
                    "type": "Computed",
                    "mandatory": true,
                    "visibleToSupplier": false,
                    "forSupplierResponse": false,
                    "dropDownType": "",
                    "dropDownValue": "",
                    "isMandatoryEnabled": false,
                    "isAllowSupplierInputEnabled": false,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 2.0,
                    "isAutoSum": true
                },
                {
                    "name": "Price per unit",
                    "type": "Currency",
                    "mandatory": true,
                    "visibleToSupplier": true,
                    "forSupplierResponse": true,
                    "dropDownType": "",
                    "dropDownValue": "",
                    "isMandatoryEnabled": true,
                    "isAllowSupplierInputEnabled": true,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 2.0,
                    "isAutoSum": false
                },
                {
                    "name": "Total price",
                    "type": "Computed",
                    "mandatory": false,
                    "visibleToSupplier": true,
                    "forSupplierResponse": false,
                    "dropDownType": "",
                    "dropDownValue": "",
                    "isMandatoryEnabled": false,
                    "isAllowSupplierInputEnabled": false,
                    "isVisible": false,
                    "isEditable": false,
                    "decimalPoints": 2.0,
                    "isAutoSum": true
                }
            ],
            "rows": [
                {
                    "rowNumber": 1,
                    "data": [
                        {
                            "columnName": null,
                            "columnValue": ""
                        },
                        {
                            "columnName": "Volume",
                            "columnValue": 12
                        },
                        {
                            "columnName": "Unit",
                            "columnValue": "14 : Shot"
                        },
                        {
                            "columnName": "Baseline price per unit",
                            "columnValue": 145
                        },
                        {
                            "columnName": "Total baseline price",
                            "columnValue": 1740.0
                        },
                        {
                            "columnName": "Price per unit",
                            "columnValue": 433
                        },
                        {
                            "columnName": "Total price",
                            "columnValue": 5196.0
                        }
                    ]
                },
                {
                    "rowNumber": 2,
                    "data": [
                        {
                            "columnName": null,
                            "columnValue": ""
                        },
                        {
                            "columnName": "Volume",
                            "columnValue": 13
                        },
                        {
                            "columnName": "Unit",
                            "columnValue": "10 : Group"
                        },
                        {
                            "columnName": "Baseline price per unit",
                            "columnValue": 8.9
                        },
                        {
                            "columnName": "Total baseline price",
                            "columnValue": 115.7
                        },
                        {
                            "columnName": "Price per unit",
                            "columnValue": 78.9
                        },
                        {
                            "columnName": "Total price",
                            "columnValue": 1025.7
                        }
                    ]
                }
            ]
        }
    ],
    "questionnaires": [
        {
            "title": "Conditional Ques",
            "createdBy": "RFxV2Buyer1 1",
            "description": "<p>Test Description - Questionnaire With QS marked Informative</p>",
            "evaluationInfo": {
                "evaluationTypeId": 1,
                "evaluationTypeName": "Technical"
            },
            "totalQuestionCount": 11,
            "isInternal": false,
            "questions": [
                {
                    "title": "<p>MATRIX OF TEXT FIELD</p>",
                    "questionType": {
                        "questionTypeName": "rfx_matrixOfTextfields",
                        "questionTypeId": 8
                    },
                    "weight": 0.0,
                    "scoreType": "Informative",
                    "isConditional": false,
                    "isMandatory": true,
                    "doAllowAttachment": true,
                    "sequenceNo": 1.0,
                    "questionRows": [
                        {
                            "rowId": 1,
                            "name": "A",
                            "score": null
                        },
                        {
                            "rowId": 2,
                            "name": "B",
                            "score": null
                        },
                        {
                            "rowId": 3,
                            "name": "C",
                            "score": null
                        }
                    ],
                    "questionColumns": [
                        {
                            "colId": 1,
                            "name": "D",
                            "type": 0,
                            "dropdownData": [
                                {
                                    "id": "1"
                                },
                                {
                                    "id": "2"
                                }
                            ],
                            "score": null
                        },
                        {
                            "colId": 2,
                            "name": "E",
                            "type": 0,
                            "dropdownData": [
                                {
                                    "id": "1"
                                },
                                {
                                    "id": "2"
                                }
                            ],
                            "score": null
                        },
                        {
                            "colId": 3,
                            "name": "F",
                            "type": 0,
                            "dropdownData": [
                                {
                                    "id": "1"
                                },
                                {
                                    "id": "2"
                                }
                            ],
                            "score": null
                        }
                    ],
                    "parentQuestion": {},
                    "decidingQuestionRow": {},
                    "attachments": [],
                    "answer": {
                        "answersData": [
                            {
                                "colId": 1,
                                "rowId": 1,
                                "value": "uyt",
                                "valueType": "string"
                            },
                            {
                                "colId": 2,
                                "rowId": 1,
                                "value": "tre",
                                "valueType": "string"
                            },
                            {
                                "colId": 3,
                                "rowId": 1,
                                "value": "rew",
                                "valueType": "string"
                            },
                            {
                                "colId": 1,
                                "rowId": 2,
                                "value": "ert",
                                "valueType": "string"
                            },
                            {
                                "colId": 2,
                                "rowId": 2,
                                "value": "ert",
                                "valueType": "string"
                            },
                            {
                                "colId": 3,
                                "rowId": 2,
                                "value": "ert",
                                "valueType": "string"
                            },
                            {
                                "colId": 1,
                                "rowId": 3,
                                "value": "tre",
                                "valueType": "string"
                            },
                            {
                                "colId": 2,
                                "rowId": 3,
                                "value": "",
                                "valueType": "string"
                            },
                            {
                                "colId": 3,
                                "rowId": 3,
                                "value": "",
                                "valueType": "string"
                            }
                        ],
                        "responseAttachments": [
                            {
                                "fileid": "64dba863-48ed-4a65-a0c0-7f9d8a8dc811",
                                "filename": "Log_ExchangeRate_Fri_28_07_2023_638261335124669785.xlsx",
                                "filesize": 19213.0
                            },
                            {
                                "fileid": "284cacba-c132-431b-8db5-571b088933e9",
                                "filename": "RFX0002872 - Questionnaires (1).xlsx",
                                "filesize": 30553.0
                            },
                            {
                                "fileid": "a21fc01b-9042-4179-bbc2-90d4bcbd5972",
                                "filename": "RFX0002872 - Questionnaires.xlsx",
                                "filesize": 44077.0
                            },
                            {
                                "fileid": "55995d2a-a187-4658-8fc2-d88d38ed46c0",
                                "filename": "RFX0002872 -Guidelines (1).docx",
                                "filesize": 17192.0
                            },
                            {
                                "fileid": "a3ffe291-bc71-4d67-94e7-b8e7ca1be47b",
                                "filename": "ExchangeRate_Fri_28_07_2023_638261335124669785.xlsx",
                                "filesize": 34423.0
                            }
                        ]
                    }
                },
                {
                    "title": "<p>MATRIX OF RADIO BUTTON</p>",
                    "questionType": {
                        "questionTypeName": "rfx_matrixOfRadio",
                        "questionTypeId": 9
                    },
                    "weight": 0.0,
                    "scoreType": "Informative",
                    "isConditional": false,
                    "isMandatory": true,
                    "doAllowAttachment": true,
                    "sequenceNo": 2.0,
                    "questionRows": [
                        {
                            "rowId": 1,
                            "name": "A",
                            "score": null
                        },
                        {
                            "rowId": 2,
                            "name": "B",
                            "score": null
                        },
                        {
                            "rowId": 3,
                            "name": "C",
                            "score": null
                        }
                    ],
                    "questionColumns": [
                        {
                            "colId": 1,
                            "name": "D",
                            "type": 1,
                            "dropdownData": [
                                {
                                    "id": "1"
                                },
                                {
                                    "id": "2"
                                }
                            ],
                            "score": null
                        },
                        {
                            "colId": 2,
                            "name": "E",
                            "type": 1,
                            "dropdownData": [
                                {
                                    "id": "1"
                                },
                                {
                                    "id": "2"
                                }
                            ],
                            "score": null
                        },
                        {
                            "colId": 3,
                            "name": "F",
                            "type": 1,
                            "dropdownData": [
                                {
                                    "id": "1"
                                },
                                {
                                    "id": "2"
                                }
                            ],
                            "score": null
                        }
                    ],
                    "parentQuestion": {},
                    "decidingQuestionRow": {},
                    "attachments": [],
                    "answer": {
                        "answersData": [
                            {
                                "colId": 1,
                                "rowId": 1,
                                "value": "1",
                                "valueType": "long"
                            },
                            {
                                "colId": 2,
                                "rowId": 2,
                                "value": "2",
                                "valueType": "long"
                            },
                            {
                                "colId": 3,
                                "rowId": 3,
                                "value": "3",
                                "valueType": "long"
                            }
                        ],
                        "responseAttachments": []
                    }
                },
                {
                    "title": "<p>MATRIX OF CHECKBOX</p>",
                    "questionType": {
                        "questionTypeName": "rfx_matrixOfCheckboxes",
                        "questionTypeId": 10
                    },
                    "weight": 0.0,
                    "scoreType": "Informative",
                    "isConditional": false,
                    "isMandatory": true,
                    "doAllowAttachment": true,
                    "sequenceNo": 3.0,
                    "questionRows": [
                        {
                            "rowId": 1,
                            "name": "A",
                            "score": null
                        },
                        {
                            "rowId": 2,
                            "name": "B",
                            "score": null
                        },
                        {
                            "rowId": 3,
                            "name": "C",
                            "score": null
                        }
                    ],
                    "questionColumns": [
                        {
                            "colId": 1,
                            "name": "D",
                            "type": 2,
                            "dropdownData": [
                                {
                                    "id": "1"
                                },
                                {
                                    "id": "2"
                                }
                            ],
                            "score": null
                        },
                        {
                            "colId": 2,
                            "name": "E",
                            "type": 2,
                            "dropdownData": [
                                {
                                    "id": "1"
                                },
                                {
                                    "id": "2"
                                }
                            ],
                            "score": null
                        },
                        {
                            "colId": 3,
                            "name": "F",
                            "type": 2,
                            "dropdownData": [
                                {
                                    "id": "1"
                                },
                                {
                                    "id": "2"
                                }
                            ],
                            "score": null
                        }
                    ],
                    "parentQuestion": {},
                    "decidingQuestionRow": {},
                    "attachments": [],
                    "answer": {
                        "answersData": [
                            {
                                "colId": 1,
                                "rowId": 1,
                                "value": "True",
                                "valueType": "bool"
                            },
                            {
                                "colId": 2,
                                "rowId": 1,
                                "value": "True",
                                "valueType": "bool"
                            },
                            {
                                "colId": 3,
                                "rowId": 1,
                                "value": "False",
                                "valueType": "bool"
                            },
                            {
                                "colId": 1,
                                "rowId": 2,
                                "value": "False",
                                "valueType": "bool"
                            },
                            {
                                "colId": 2,
                                "rowId": 2,
                                "value": "False",
                                "valueType": "bool"
                            },
                            {
                                "colId": 3,
                                "rowId": 2,
                                "value": "False",
                                "valueType": "bool"
                            },
                            {
                                "colId": 1,
                                "rowId": 3,
                                "value": "False",
                                "valueType": "bool"
                            },
                            {
                                "colId": 2,
                                "rowId": 3,
                                "value": "False",
                                "valueType": "bool"
                            },
                            {
                                "colId": 3,
                                "rowId": 3,
                                "value": "False",
                                "valueType": "bool"
                            }
                        ],
                        "responseAttachments": [
                            {
                                "fileid": "af044632-44b6-49b4-b874-db56aafadf37",
                                "filename": "RFX0002872 -Guidelines.docx",
                                "filesize": 10000.0
                            },
                            {
                                "fileid": "c7573735-a18a-4caf-b410-c7dea3b3e504",
                                "filename": "RFX0002872 -Guidelines (1).docx",
                                "filesize": 17192.0
                            },
                            {
                                "fileid": "3471c2e1-50ce-4f7e-ad72-647a033fb092",
                                "filename": "RFX0002872 - Pricesheet (1).xlsx",
                                "filesize": 72097.0
                            }
                        ]
                    }
                },
                {
                    "title": "<p>ATTACHMENT ONLY</p>",
                    "questionType": {
                        "questionTypeName": "rfx_attachmentOnly",
                        "questionTypeId": 16
                    },
                    "weight": 0.0,
                    "scoreType": "Informative",
                    "isConditional": false,
                    "isMandatory": true,
                    "doAllowAttachment": true,
                    "sequenceNo": 4.0,
                    "questionRows": [],
                    "questionColumns": [],
                    "parentQuestion": {},
                    "decidingQuestionRow": {},
                    "attachments": [],
                    "answer": {
                        "answersData": [
                            {
                                "colId": 1,
                                "rowId": 1,
                                "value": "",
                                "valueType": "string"
                            }
                        ],
                        "responseAttachments": [
                            {
                                "fileid": "f0e4c186-9743-4121-a101-22c757b9707e",
                                "filename": "ExchangeRate_Fri_28_07_2023_638261335124669785.xlsx",
                                "filesize": 34423.0
                            },
                            {
                                "fileid": "b0e58667-c9e9-444f-9d3b-7aa447fff4f7",
                                "filename": "RFX0002872 -Guidelines (1) (1).docx",
                                "filesize": 17192.0
                            },
                            {
                                "fileid": "3e61357f-8676-4f4b-866c-07ee98a9cd4f",
                                "filename": "RFX0002872 - Questionnaires (1).xlsx",
                                "filesize": 30553.0
                            }
                        ]
                    }
                },
                {
                    "title": "<p>Radio</p>",
                    "questionType": {
                        "questionTypeName": "rfx_radioButton",
                        "questionTypeId": 4
                    },
                    "weight": 33.33,
                    "scoreType": "Score",
                    "isConditional": false,
                    "isMandatory": false,
                    "doAllowAttachment": false,
                    "sequenceNo": 5.0,
                    "questionRows": [
                        {
                            "rowId": 1,
                            "name": "RB1",
                            "score": 2.0
                        },
                        {
                            "rowId": 2,
                            "name": "RB2",
                            "score": 2.0
                        }
                    ],
                    "questionColumns": [],
                    "parentQuestion": {},
                    "decidingQuestionRow": {},
                    "attachments": [],
                    "answer": {
                        "answersData": [
                            {
                                "colId": 1,
                                "rowId": 2,
                                "value": "RB2",
                                "valueType": "string"
                            }
                        ],
                        "responseAttachments": []
                    }
                },
                {
                    "title": "<p>COMBINATION MATRIX</p>",
                    "questionType": {
                        "questionTypeName": "rfx_combinationMatrix",
                        "questionTypeId": 13
                    },
                    "weight": 0.0,
                    "scoreType": "Informative",
                    "isConditional": true,
                    "isMandatory": true,
                    "doAllowAttachment": true,
                    "sequenceNo": 6.0,
                    "questionRows": [
                        {
                            "rowId": 1,
                            "name": "A",
                            "score": null
                        },
                        {
                            "rowId": 2,
                            "name": "B",
                            "score": null
                        },
                        {
                            "rowId": 3,
                            "name": "C",
                            "score": null
                        }
                    ],
                    "questionColumns": [
                        {
                            "colId": 1,
                            "name": "C",
                            "type": 0,
                            "dropdownData": [
                                {
                                    "id": "1"
                                },
                                {
                                    "id": "2"
                                }
                            ],
                            "score": null
                        },
                        {
                            "colId": 2,
                            "name": "D",
                            "type": 1,
                            "dropdownData": [
                                {
                                    "id": "1"
                                },
                                {
                                    "id": "2"
                                }
                            ],
                            "score": null
                        },
                        {
                            "colId": 3,
                            "name": "E",
                            "type": 2,
                            "dropdownData": [
                                {
                                    "id": "1"
                                },
                                {
                                    "id": "2"
                                }
                            ],
                            "score": null
                        },
                        {
                            "colId": 4,
                            "name": "F",
                            "type": 3,
                            "dropdownData": [
                                {
                                    "id": "1",
                                    "value": "A",
                                    "score": 1.0
                                },
                                {
                                    "id": "2",
                                    "value": "B",
                                    "score": 2.0
                                }
                            ],
                            "score": null
                        },
                        {
                            "colId": 5,
                            "name": "G",
                            "type": 4,
                            "dropdownData": [
                                {
                                    "id": "1"
                                },
                                {
                                    "id": "2"
                                }
                            ],
                            "score": null
                        }
                    ],
                    "parentQuestion": {
                        "id": "f384762c-da5b-4c1d-a741-86c30d782a46",
                        "questionText": "Radio"
                    },
                    "decidingQuestionRow": {
                        "name": "RB1",
                        "rowId": 1
                    },
                    "attachments": [],
                    "answer": {
                        "answersData": [
                            {
                                "colId": 1,
                                "rowId": 1,
                                "valueType": "string",
                                "value": ""
                            },
                            {
                                "colId": 2,
                                "rowId": null,
                                "valueType": "long",
                                "value": null
                            },
                            {
                                "colId": 3,
                                "rowId": 1,
                                "valueType": "bool",
                                "value": "False"
                            },
                            {
                                "colId": 4,
                                "rowId": 1,
                                "valueType": "string",
                                "value": ""
                            },
                            {
                                "colId": 5,
                                "rowId": 1,
                                "valueType": "decimal",
                                "value": null
                            },
                            {
                                "colId": 1,
                                "rowId": 2,
                                "valueType": "string",
                                "value": ""
                            },
                            {
                                "colId": 2,
                                "rowId": null,
                                "valueType": "long",
                                "value": null
                            },
                            {
                                "colId": 3,
                                "rowId": 2,
                                "valueType": "bool",
                                "value": "False"
                            },
                            {
                                "colId": 4,
                                "rowId": 2,
                                "valueType": "string",
                                "value": ""
                            },
                            {
                                "colId": 5,
                                "rowId": 2,
                                "valueType": "decimal",
                                "value": null
                            },
                            {
                                "colId": 1,
                                "rowId": 3,
                                "valueType": "string",
                                "value": ""
                            },
                            {
                                "colId": 2,
                                "rowId": null,
                                "valueType": "long",
                                "value": null
                            },
                            {
                                "colId": 3,
                                "rowId": 3,
                                "valueType": "bool",
                                "value": "False"
                            },
                            {
                                "colId": 4,
                                "rowId": 3,
                                "valueType": "string",
                                "value": ""
                            },
                            {
                                "colId": 5,
                                "rowId": 3,
                                "valueType": "decimal",
                                "value": null
                            }
                        ],
                        "responseAttachments": []
                    }
                },
                {
                    "title": "<p>DATE AND TIME</p>",
                    "questionType": {
                        "questionTypeName": "rfx_dateAndTime",
                        "questionTypeId": 12
                    },
                    "weight": 0.0,
                    "scoreType": "Informative",
                    "isConditional": true,
                    "isMandatory": true,
                    "doAllowAttachment": true,
                    "sequenceNo": 7.0,
                    "questionRows": [],
                    "questionColumns": [],
                    "parentQuestion": {
                        "id": "f384762c-da5b-4c1d-a741-86c30d782a46",
                        "questionText": "Radio"
                    },
                    "decidingQuestionRow": {
                        "name": "RB2",
                        "rowId": 2
                    },
                    "attachments": [],
                    "answer": {
                        "answersData": [
                            {
                                "colId": 1,
                                "rowId": 1,
                                "value": "12-09-1999",
                                "valueType": "string"
                            }
                        ],
                        "responseAttachments": []
                    }
                },
                {
                    "title": "<p>Checkbox</p>",
                    "questionType": {
                        "questionTypeName": "rfx_checkboxes",
                        "questionTypeId": 5
                    },
                    "weight": 33.33,
                    "scoreType": "Score",
                    "isConditional": false,
                    "isMandatory": false,
                    "doAllowAttachment": false,
                    "sequenceNo": 8.0,
                    "questionRows": [
                        {
                            "rowId": 1,
                            "name": "CB1",
                            "score": 2.0
                        },
                        {
                            "rowId": 2,
                            "name": "CB2",
                            "score": 3.0
                        }
                    ],
                    "questionColumns": [],
                    "parentQuestion": {
                        "id": null,
                        "questionText": null
                    },
                    "decidingQuestionRow": {
                        "name": null,
                        "rowId": 0
                    },
                    "attachments": [],
                    "answer": {
                        "answersData": [
                            {
                                "colId": 1,
                                "rowId": 1,
                                "value": "True",
                                "valueType": "bool"
                            },
                            {
                                "colId": 1,
                                "rowId": 2,
                                "value": "True",
                                "valueType": "bool"
                            }
                        ],
                        "responseAttachments": []
                    }
                },
                {
                    "title": "<p>TABLE TYPE QUESTION</p>",
                    "questionType": {
                        "questionTypeName": "rfx_tableType",
                        "questionTypeId": 14
                    },
                    "weight": 0.0,
                    "scoreType": "Informative",
                    "isConditional": true,
                    "isMandatory": true,
                    "doAllowAttachment": true,
                    "sequenceNo": 9.0,
                    "questionRows": [
                        {
                            "rowId": 1,
                            "name": "",
                            "score": null
                        }
                    ],
                    "questionColumns": [
                        {
                            "colId": 1,
                            "name": "A",
                            "type": 0,
                            "dropdownData": [
                                {
                                    "id": "1"
                                },
                                {
                                    "id": "2"
                                }
                            ],
                            "score": null
                        },
                        {
                            "colId": 2,
                            "name": "B",
                            "type": 1,
                            "dropdownData": [
                                {
                                    "id": "1"
                                },
                                {
                                    "id": "2"
                                }
                            ],
                            "score": null
                        },
                        {
                            "colId": 3,
                            "name": "C",
                            "type": 2,
                            "dropdownData": [
                                {
                                    "id": "1"
                                },
                                {
                                    "id": "2"
                                }
                            ],
                            "score": null
                        },
                        {
                            "colId": 4,
                            "name": "D",
                            "type": 3,
                            "dropdownData": [
                                {
                                    "id": "1",
                                    "value": "A",
                                    "score": 1.0
                                },
                                {
                                    "id": "2",
                                    "value": "B",
                                    "score": 2.0
                                }
                            ],
                            "score": null
                        },
                        {
                            "colId": 5,
                            "name": "E",
                            "type": 4,
                            "dropdownData": [
                                {
                                    "id": "1"
                                },
                                {
                                    "id": "2"
                                }
                            ],
                            "score": null
                        }
                    ],
                    "parentQuestion": {
                        "id": "88b41558-8490-4887-a73a-c6f0b718f662",
                        "questionText": "Checkbox"
                    },
                    "decidingQuestionRow": {
                        "name": "CB1",
                        "rowId": 1
                    },
                    "attachments": [],
                    "answer": {
                        "answersData": [
                            {
                                "colId": 1,
                                "rowId": 1,
                                "value": "qwe",
                                "valueType": "string"
                            },
                            {
                                "colId": 2,
                                "rowId": 1,
                                "value": "1",
                                "valueType": "long"
                            },
                            {
                                "colId": 3,
                                "rowId": 1,
                                "value": "True",
                                "valueType": "bool"
                            },
                            {
                                "colId": 4,
                                "rowId": 1,
                                "value": "A",
                                "valueType": "string"
                            },
                            {
                                "colId": 5,
                                "rowId": 1,
                                "value": "23",
                                "valueType": "decimal"
                            }
                        ],
                        "responseAttachments": []
                    }
                },
                {
                    "title": "<p>MATRIX OF DROPDOWN</p>",
                    "questionType": {
                        "questionTypeName": "rfx_matrixOfDropdown",
                        "questionTypeId": 11
                    },
                    "weight": 0.0,
                    "scoreType": "Informative",
                    "isConditional": true,
                    "isMandatory": true,
                    "doAllowAttachment": true,
                    "sequenceNo": 10.0,
                    "questionRows": [
                        {
                            "rowId": 1,
                            "name": "A",
                            "score": null
                        },
                        {
                            "rowId": 2,
                            "name": "B",
                            "score": null
                        },
                        {
                            "rowId": 3,
                            "name": "C",
                            "score": null
                        }
                    ],
                    "questionColumns": [
                        {
                            "colId": 1,
                            "name": "D",
                            "type": 3,
                            "dropdownData": [
                                {
                                    "id": "1",
                                    "value": "A",
                                    "score": 1.0
                                },
                                {
                                    "id": "2",
                                    "value": "B",
                                    "score": 2.0
                                }
                            ],
                            "score": null
                        },
                        {
                            "colId": 2,
                            "name": "E",
                            "type": 3,
                            "dropdownData": [
                                {
                                    "id": "1",
                                    "value": "A",
                                    "score": 1.0
                                },
                                {
                                    "id": "2",
                                    "value": "B",
                                    "score": 2.0
                                }
                            ],
                            "score": null
                        },
                        {
                            "colId": 3,
                            "name": "F",
                            "type": 3,
                            "dropdownData": [
                                {
                                    "id": "1",
                                    "value": "A",
                                    "score": 1.0
                                },
                                {
                                    "id": "2",
                                    "value": "B",
                                    "score": 2.0
                                }
                            ],
                            "score": null
                        }
                    ],
                    "parentQuestion": {
                        "id": "88b41558-8490-4887-a73a-c6f0b718f662",
                        "questionText": "Checkbox"
                    },
                    "decidingQuestionRow": {
                        "name": "CB2",
                        "rowId": 2
                    },
                    "attachments": [],
                    "answer": {
                        "answersData": [
                            {
                                "colId": 1,
                                "rowId": 1,
                                "value": "A",
                                "valueType": "string"
                            },
                            {
                                "colId": 2,
                                "rowId": 1,
                                "value": "B",
                                "valueType": "string"
                            },
                            {
                                "colId": 3,
                                "rowId": 1,
                                "value": "",
                                "valueType": "string"
                            },
                            {
                                "colId": 1,
                                "rowId": 2,
                                "value": "",
                                "valueType": "string"
                            },
                            {
                                "colId": 2,
                                "rowId": 2,
                                "value": "",
                                "valueType": "string"
                            },
                            {
                                "colId": 3,
                                "rowId": 2,
                                "value": "B",
                                "valueType": "string"
                            },
                            {
                                "colId": 1,
                                "rowId": 3,
                                "value": "",
                                "valueType": "string"
                            },
                            {
                                "colId": 2,
                                "rowId": 3,
                                "value": "",
                                "valueType": "string"
                            },
                            {
                                "colId": 3,
                                "rowId": 3,
                                "value": "",
                                "valueType": "string"
                            }
                        ],
                        "responseAttachments": []
                    }
                },
                {
                    "title": "<p>Single</p>",
                    "questionType": {
                        "questionTypeName": "rfx_singleLineText",
                        "questionTypeId": 1
                    },
                    "weight": 33.34,
                    "scoreType": "Score",
                    "isConditional": false,
                    "isMandatory": false,
                    "doAllowAttachment": false,
                    "sequenceNo": 11.0,
                    "questionRows": [],
                    "questionColumns": [],
                    "parentQuestion": {
                        "id": null,
                        "questionText": null
                    },
                    "decidingQuestionRow": {
                        "name": null,
                        "rowId": 0
                    },
                    "attachments": [],
                    "answer": {
                        "answersData": [
                            {
                                "colId": 1,
                                "rowId": 1,
                                "value": "poi",
                                "valueType": "string"
                            }
                        ],
                        "responseAttachments": []
                    }
                }
            ]
        },
        {
            "title": "Scoring Ques",
            "createdBy": "RFxV2Buyer1 1",
            "description": "<Font Style=\"FONT-FAMILY: Calibri;FONT-SIZE: 11pt;COLOR: #000000;\">Technicallllllll11</Font>",
            "evaluationInfo": {
                "evaluationTypeId": 1,
                "evaluationTypeName": "Technical"
            },
            "totalQuestionCount": 0,
            "isInternal": false,
            "questions": [
                {
                    "title": "SECTION",
                    "questionType": {
                        "questionTypeId": 15,
                        "questionTypeName": "LabelTypeQuestion"
                    },
                    "weight": 0.0,
                    "scoreType": "Score",
                    "isConditional": false,
                    "isMandatory": false,
                    "doAllowAttachment": false,
                    "sequenceNo": 1.0,
                    "questionRows": [
                        {
                            "rowId": 1,
                            "name": "866c98ce-d5e4-4cec-9048-dbcc619308f2",
                            "score": 0.0
                        }
                    ],
                    "questionColumns": [],
                    "parentQuestion": {
                        "questionText": null
                    },
                    "decidingQuestionRow": {
                        "rowId": 0,
                        "name": null
                    },
                    "attachments": [],
                    "answer": {
                        "answersData": null,
                        "responseAttachments": null
                    }
                },
                {
                    "title": "<p>Single Line</p>",
                    "questionType": {
                        "questionTypeId": 1,
                        "questionTypeName": "FreeFormSinglelineText"
                    },
                    "weight": 14.29,
                    "scoreType": "Score",
                    "isConditional": false,
                    "isMandatory": true,
                    "doAllowAttachment": false,
                    "sequenceNo": 2.0,
                    "questionRows": [
                        {
                            "rowId": 1,
                            "name": "",
                            "score": 0.0
                        }
                    ],
                    "questionColumns": [],
                    "parentQuestion": {
                        "questionText": null
                    },
                    "decidingQuestionRow": {
                        "rowId": 0,
                        "name": null
                    },
                    "attachments": [],
                    "answer": {
                        "answersData": [
                            {
                                "colId": 1,
                                "rowId": 1,
                                "value": "qq",
                                "valueType": "string"
                            }
                        ],
                        "responseAttachments": []
                    }
                },
                {
                    "title": "<p>Multi Line</p>",
                    "questionType": {
                        "questionTypeId": 2,
                        "questionTypeName": "FreeFormMultilineText"
                    },
                    "weight": 14.29,
                    "scoreType": "Score",
                    "isConditional": false,
                    "isMandatory": true,
                    "doAllowAttachment": false,
                    "sequenceNo": 3.0,
                    "questionRows": [
                        {
                            "rowId": 1,
                            "name": "",
                            "score": 0.0
                        }
                    ],
                    "questionColumns": [],
                    "parentQuestion": {
                        "questionText": null
                    },
                    "decidingQuestionRow": {
                        "rowId": 0,
                        "name": null
                    },
                    "attachments": [],
                    "answer": {
                        "answersData": [
                            {
                                "colId": 1,
                                "rowId": 1,
                                "value": "qqqq",
                                "valueType": "string"
                            }
                        ],
                        "responseAttachments": []
                    }
                },
                {
                    "title": "<p>Rich Text</p>",
                    "questionType": {
                        "questionTypeId": 3,
                        "questionTypeName": "FreeFormRichText"
                    },
                    "weight": 14.29,
                    "scoreType": "Score",
                    "isConditional": false,
                    "isMandatory": true,
                    "doAllowAttachment": false,
                    "sequenceNo": 4.0,
                    "questionRows": [
                        {
                            "rowId": 1,
                            "name": "",
                            "score": 0.0
                        }
                    ],
                    "questionColumns": [],
                    "parentQuestion": {
                        "questionText": null
                    },
                    "decidingQuestionRow": {
                        "rowId": 0,
                        "name": null
                    },
                    "attachments": [],
                    "answer": {
                        "answersData": [
                            {
                                "colId": 1,
                                "rowId": 1,
                                "value": "qqqqqqq",
                                "valueType": "string"
                            }
                        ],
                        "responseAttachments": []
                    }
                },
                {
                    "title": "SECTIONS",
                    "questionType": {
                        "questionTypeName": "rfx_section",
                        "questionTypeId": 15
                    },
                    "weight": 0.0,
                    "scoreType": "Score",
                    "isConditional": false,
                    "isMandatory": false,
                    "doAllowAttachment": false,
                    "sequenceNo": 5.0,
                    "questionRows": [],
                    "questionColumns": [],
                    "parentQuestion": {},
                    "decidingQuestionRow": {},
                    "attachments": [],
                    "answer": {
                        "answersData": null,
                        "responseAttachments": null
                    }
                },
                {
                    "title": "<p>Radio Button</p>",
                    "questionType": {
                        "questionTypeName": "rfx_radioButton",
                        "questionTypeId": 4
                    },
                    "weight": 14.29,
                    "scoreType": "Score",
                    "isConditional": false,
                    "isMandatory": false,
                    "doAllowAttachment": false,
                    "sequenceNo": 6.0,
                    "questionRows": [
                        {
                            "rowId": 1,
                            "name": "RB1",
                            "score": 2.0
                        },
                        {
                            "rowId": 2,
                            "name": "RB2",
                            "score": 3.0
                        }
                    ],
                    "questionColumns": [],
                    "parentQuestion": {},
                    "decidingQuestionRow": {},
                    "attachments": [],
                    "answer": {
                        "answersData": [
                            {
                                "colId": 1,
                                "rowId": 2,
                                "value": "RB2",
                                "valueType": "string"
                            }
                        ],
                        "responseAttachments": []
                    }
                },
                {
                    "title": "<p>Checkbox</p>",
                    "questionType": {
                        "questionTypeName": "rfx_checkboxes",
                        "questionTypeId": 5
                    },
                    "weight": 14.29,
                    "scoreType": "Score",
                    "isConditional": false,
                    "isMandatory": false,
                    "doAllowAttachment": false,
                    "sequenceNo": 7.0,
                    "questionRows": [
                        {
                            "rowId": 1,
                            "name": "CB1",
                            "score": 2.0
                        },
                        {
                            "rowId": 2,
                            "name": "CB2",
                            "score": 4.0
                        }
                    ],
                    "questionColumns": [],
                    "parentQuestion": {},
                    "decidingQuestionRow": {},
                    "attachments": [],
                    "answer": {
                        "answersData": [
                            {
                                "colId": 1,
                                "rowId": 1,
                                "value": "True",
                                "valueType": "bool"
                            },
                            {
                                "colId": 1,
                                "rowId": 2,
                                "value": "True",
                                "valueType": "bool"
                            }
                        ],
                        "responseAttachments": []
                    }
                },
                {
                    "title": "<p>DropDown</p>",
                    "questionType": {
                        "questionTypeName": "rfx_dropdown",
                        "questionTypeId": 7
                    },
                    "weight": 14.29,
                    "scoreType": "Score",
                    "isConditional": false,
                    "isMandatory": false,
                    "doAllowAttachment": false,
                    "sequenceNo": 8.0,
                    "questionRows": [
                        {
                            "rowId": 1,
                            "name": "DD1",
                            "score": 3.0
                        },
                        {
                            "rowId": 2,
                            "name": "DD2",
                            "score": 3.0
                        }
                    ],
                    "questionColumns": [],
                    "parentQuestion": {},
                    "decidingQuestionRow": {},
                    "attachments": [],
                    "answer": {
                        "answersData": [
                            {
                                "colId": 1,
                                "rowId": 1,
                                "value": "DD1",
                                "valueType": "string"
                            }
                        ],
                        "responseAttachments": []
                    }
                },
                {
                    "title": "<p>Multi</p>",
                    "questionType": {
                        "questionTypeName": "rfx_multiLineText",
                        "questionTypeId": 2
                    },
                    "weight": 14.26,
                    "scoreType": "Score",
                    "isConditional": false,
                    "isMandatory": true,
                    "doAllowAttachment": true,
                    "sequenceNo": 9.0,
                    "questionRows": [],
                    "questionColumns": [],
                    "parentQuestion": {},
                    "decidingQuestionRow": {},
                    "attachments": [],
                    "answer": {
                        "answersData": [
                            {
                                "colId": 1,
                                "rowId": 1,
                                "value": "qwerty",
                                "valueType": "string"
                            }
                        ],
                        "responseAttachments": []
                    }
                }
            ]
        }
    ],
    "scorecard": {
        "title": "rfx_scorecardDefault",
        "questionnaireScoreWeight": 50.0,
        "pricesheetScoreWeight": 50.0,
        "scores": {
            "supplierId": 538853,
            "supplierName": "qcTest2LeoSMB",
            "pricesheetScore": 4.166625000000001,
            "questionnaireScore": 4.409655,
            "eventScore": 4.28814,
            "clientSupplierCode": ""
        },
        "individualPricesheetWeight": [
            {
                "id": "4723e8e3-e583-4a74-9163-ccb66fc0c14a",
                "title": "PS_001",
                "weight": 33.33
            },
            {
                "id": "4ceff714-6ff3-4746-a45a-f18a03b59cbf",
                "title": "SRF Material Price Sheet",
                "weight": 33.33
            },
            {
                "id": "8a2f3346-f12b-4cf1-ac71-c604d391ecd7",
                "title": "PS_002",
                "weight": 33.34
            }
        ],
        "individualQuestionnaireWeight": [
            {
                "id": "323754ee-73dd-4087-9002-9d14006ef5c1",
                "title": "Scoring Ques",
                "weight": 50.0
            },
            {
                "id": "46c41cce-49e8-4e79-8d94-ea05aae6e318",
                "title": "Conditional Ques",
                "weight": 50.0
            }
        ],
        "evaluators": [
            {
                "id": "7002220104000005",
                "clientCode": 7002220104000005,
                "name": "RFxV2Buyer1 1"
            },
            {
                "id": "7002220104000007",
                "clientCode": 7002220104000007,
                "name": "SMB Buyer1"
            }
        ],
        "priceSheetAssigment": [
            {
                "id": "4723e8e3-e583-4a74-9163-ccb66fc0c14a",
                "contactCode": 7002220104000005,
                "isAssigned": true
            },
            {
                "id": "4723e8e3-e583-4a74-9163-ccb66fc0c14a",
                "contactCode": 7002220104000007,
                "isAssigned": true
            },
            {
                "id": "4ceff714-6ff3-4746-a45a-f18a03b59cbf",
                "contactCode": 7002220104000005,
                "isAssigned": true
            },
            {
                "id": "4ceff714-6ff3-4746-a45a-f18a03b59cbf",
                "contactCode": 7002220104000007,
                "isAssigned": true
            },
            {
                "id": "8a2f3346-f12b-4cf1-ac71-c604d391ecd7",
                "contactCode": 7002220104000005,
                "isAssigned": true
            },
            {
                "id": "8a2f3346-f12b-4cf1-ac71-c604d391ecd7",
                "contactCode": 7002220104000007,
                "isAssigned": true
            }
        ],
        "questionnaireAssignment": [
            {
                "id": "323754ee-73dd-4087-9002-9d14006ef5c1",
                "contactCode": 7002220104000005,
                "isAssigned": true
            },
            {
                "id": "323754ee-73dd-4087-9002-9d14006ef5c1",
                "contactCode": 7002220104000007,
                "isAssigned": true
            },
            {
                "id": "46c41cce-49e8-4e79-8d94-ea05aae6e318",
                "contactCode": 7002220104000005,
                "isAssigned": true
            },
            {
                "id": "46c41cce-49e8-4e79-8d94-ea05aae6e318",
                "contactCode": 7002220104000007,
                "isAssigned": true
            }
        ]
    },
    "awardAllocationSummary": null,
    "awardDetails": {
        "supplierName": "qcTest2LeoSMB",
        "supplierStatus": "Awarded",
        "updatedBy": "RFxV2Buyer1 1",
        "emailSentOn": "07/28/2023 11:21:06",
        "spendAllocated": 2823.0,
        "volumeAllocatedPercentage": 0.0,
        "commentText": "ffffff",
        "reasonForAwarding": "Total cost of ownership (Cost + Overhead to Manage)",
        "clientSupplierCode": null
    },
    "linkedDocuments": [],
    "documentId": "562a18ad-38b9-4754-a319-685c531bf76d",
    "count": 903,
    "_id": "fd729d1f-c64e-46f3-aded-e0bbc262a783"
}

Data Elements

Field Name

Data Type

Description

Validations

eventType

String

Type of event (e.g., "Request For Proposal")

Required

eventCurrency

String

Currency for the event (e.g., "AUD")

Required, must be a valid currency code

eventValue

String

Value associated with the event (e.g., "1234")

Required, numeric string

documentName

String

Name of the document (e.g., "SRF-RFx")

Required

documentNumber

String

Unique identifier for the document (e.g., "RFX0002872")

Required

documentDescription

String

Description of the document (e.g., "Request")

Required

creationDateTime

String

Timestamp of document creation (e.g., "07/28/2023 06:16:35")

Required, valid date-time format

documentCreator

String

ID of the document creator

Required

documentClientContactCode

String

Client contact code for the document

Required

documentCreatorUserName

String

Username of the document creator

Required

documentCreatorFullName

String

Full name of the document creator

Required

category

Array of Strings

Categories associated with the document

Optional

region

Array of Objects

Geographic regions associated with the document

Optional

attachments

Array of Objects

List of file attachments

Optional

documentBU

Array of Objects

Business Unit information

Required

linkedDocumentHierarchy

Object

Hierarchical relationships of linked documents

Required

customFields

Array of Objects

Custom fields for additional information

Optional

documentStatus

String

Current status of the document (e.g., "Awarded")

Required

eventTimeline

Array of Objects

Timeline of events related to the document

Required

suppliers

Array of Objects

List of suppliers associated with the document

Required

documentSupplierDetails

Object

Summary of supplier participation

Required

teamMembers

Array of Objects

List of team members involved in the document

Required

pricesheets

Array of Objects

Price sheets associated with the document

Required

questionnaires

Array of Objects

Questionnaires linked to the document

Required

scorecard

Object

Scorecard details for evaluating suppliers

Required

awardAllocationSummary

Object or Null

Summary of award allocation (if applicable)

Optional

awardDetails

Object

Details of the award made to a supplier

Required

linkedDocuments

Array of Objects

List of documents linked to this document

Optional

documentId

String

Unique identifier for the document

Required

count

Integer

Count of related entities or items

Required, must be a non-negative integer

_id

String

Unique identifier for the JSON object

Required

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 


 

Attachments

Field Name

Data Type

Description

Validations

name

String

Name of the attachment file

Required

isVisibleToSupplier

Boolean

Indicates if the attachment is visible to the supplier

Required

classificationType

Object

Classification type details (structure not specified)

Optional

createdBy

String

Name of the person who created the attachment

Required

createdOn

String

Timestamp of when the attachment was created

Required, valid date-time format

fileSize

String

Size of the attachment file

Required

sasUri

String

URL to access the attachment

Required, must be a valid URL

 
 
 
 
 
 
 
 
 
 
 
 


 

Document Business Unit

Field Name

Data Type

Description

Validations

entityCode

String

Unique code for the business unit

Required

entityType

String

Type of the entity (e.g., "BusinessUnit")

Required

isDefault

Boolean

Indicates if this is the default business unit

Required

LOBEntityCode

String or Null

Line of business entity code (if applicable)

Optional

 
 
 
 
 
 
 
 
 


 

Event Timeline

Field Name

Data Type

Description

Validations

Response

Object

Timeline details for the response

Required

- name

String

Name of the response timeline

Required

- startDate

String

Start date of the timeline

Required, valid date-time format

- endDate

String

End date of the timeline

Required, valid date-time format

- visibleToSupplier

Boolean

Visibility of the timeline to suppliers

Required

 
 
 
 
 
 
 
 
 
 


 

Suppliers

Field Name

Data Type

Description

Validations

name

String

Name of the supplier

Required

clientSupplierCode

String or Null

Code for the client supplier

Optional

primaryRespondant

String

Email of the primary respondent

Required, must be a valid email format

shortlistedForFeedback

Boolean

Indicates if the supplier is shortlisted

Required

supplierContacts

Array of Objects

List of contacts associated with the supplier

Required

responseCompletionStatus

String

Status of the supplier's response

Required

participationStatus

String

Participation status of the supplier

Required

partnerCode

Integer

Code for the supplier partner

Required

profileStatus

String or Null

Status of the supplier profile

Optional

sourceSystemInformation

Object

Information about the source system

Required

- name

String

Name of the source system

Required

- sourceIdentificationNo

String or Null

Identification number of the source system

Optional

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 


 

Team Members

Field Name

Data Type

Description

Validations

firstName

String

First name of the team member

Required

lastName

String

Last name of the team member

Required

clientContactCode

String

Client contact code of the team member

Required

emailAddress

String

Email address of the team member

Required, must be a valid email format

groupId

String

ID of the group the member belongs to

Required

groupName

String

Name of the group

Optional

invitationStatus

String

Status of the invitation

Required

evaluationAccess

String

Access level for evaluation

Required

coAuthoringAccess

String

Access level for co-authoring

Required

isApprover

Boolean

Indicates if the team member is an approver

Required

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 


 

Pricesheet

Field Name

Data Type

Description

Validations

priceSheetName

String

Name of the price sheet

Required

description

String

Description of the price sheet

Optional

priceSheetType

String

Type of the price sheet

Required

createdBy

String

ID of the creator

Required

lastModifiedBy

String

ID of the last modifier

Required

columns

Array of Objects

List of columns in the price sheet

Required

rows

Array of Objects

List of rows in the price sheet

Required

 
 
 
 
 
 
 
 
 
 
 
 


 

Questionnaires

Field Name

Data Type

Description

Validations

title

String

Title of the questionnaire

Required

createdBy

String

Name of the person who created the questionnaire

Required

description

String

Description of the questionnaire

Optional

evaluationInfo

Object

Information related to evaluation

Required

- evaluationTypeId

Integer

ID of the evaluation type

Required

- evaluationTypeName

String

Name of the evaluation type

Required

totalQuestionCount

Integer

Total number of questions in the questionnaire

Required

isInternal

Boolean

Indicates if the questionnaire is internal

Required

questions

Array of Objects

List of questions in the questionnaire

Required


 

Scorecard

Field Name

Data Type

Description

Validations

title

String

Title of the scorecard

Required

questionnaireScoreWeight

Float

Weight of the questionnaire score

Required

pricesheetScoreWeight

Float

Weight of the price sheet score

Required

scores

Object

Scores related to the suppliers

Required

- supplierId

Integer

ID of the supplier

Required

- supplierName

String

Name of the supplier

Required

- pricesheetScore

Float

Score for the price sheet

Required

- questionnaireScore

Float

Score for the questionnaire

Required

individualPricesheetWeight

Array of Objects

Weight for individual price sheets

Optional

individualQuestionnaireWeight

Array of Objects

Weight for individual questionnaires

Optional

evaluators

Array of Objects

List of evaluators for the scorecard

Required

priceSheetAssigment

Array of Objects

Assignment of price sheets

Required

questionnaireAssignment

Array of Objects

Assignment of questionnaires

Required

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 


 

Award Details

Field Name

Data Type

Description

Validations

supplierName

String

Name of the supplier awarded the contract

Required

supplierStatus

String

Current status of the supplier (e.g., "Awarded")

Required, must be one of predefined statuses (e.g., "Awarded", "Not Awarded")

updatedBy

String

Name of the person who updated the award details

Required

emailSentOn

String

Timestamp when the award notification email was sent

Required, valid date-time format

spendAllocated

Float

Total spend allocated to the supplier

Required, must be a non-negative float

volumeAllocatedPercentage

Float

Percentage of volume allocated to the supplier

Required, must be between 0 and 100

commentText

String

Additional comments regarding the award

Optional

reasonForAwarding

String

Justification for awarding the contract to the supplier

Required

clientSupplierCode

String or Null

Client's code for the supplier, if applicable

Optional