CODEWITHSUNDEEP
rsa-archer-grcsap-ariba
frango_mints
frango_mints

Reputation: 59

Using SAP Ariba Open API's, is it possible to export a Supplier's Qualification Questionnaire into RSA Archer?

Summary: I am a buyer who wants to integrate SAP Ariba with Archer using the SAP Ariba Open API's. During the Supplier Lifecycle & Performance Management process, my potential suppliers fill out a questionnaire to meet the Supplier Qualification step. I would like to automate the export of this completed questionnaire.

Things I've tried: Attempted to access API documentation but it is locked behind a paywall Contacted support and learned this can be done manually by exporting the completed questionnaire into a CSV.

Ideally: the Ariba Open API's allow me to export the supplier's completed questionnaire and import into Archer.

Upvotes: 0

Views: 1054

Answers (3)

Mohannad Otaibi
Mohannad Otaibi

Reputation: 19

1- You will need access to supplier data with pagination api.

2- Get the list of questionnaires, get the questionnaireId and workspace Id.

Sample Request

curl --request POST \
  --url 'https://mn2.openapi.ariba.com/api/supplierdatapagination/v4/prod/vendorDataRequests?realm={YOUR_REALM}&%24count=true' \
  --header 'Authorization: Bearer {BEARER_TOKEN}' \
  --header 'Content-Type: application/json' \
  --header 'apiKey: {APPLICATION_API_KEY}' \
  --data '{
  "withQuestionnaire": true,
  "outputFormat": "JSON",
  "withGenericCustomFields":false,
  "smVendorIds": ["{VENDOR_ID}"]
}'

Sample Response:

[
    {
        "SM Vendor ID": "XXXXXXXXXXXXX",
        "Registration Status": "PendingApproval",
        "Qualification Status": "NotQualified",
        "Integrated to ERP": "NotIntegrated",
        "questionnaires": [
            {
                "questionnaireId": "Doc###**#**#########",
                "questionnaireTitle": "Supplier Registration Questionnaire",
                "workspaceType": "REGISTRATION",
                "workspaceId": "**WS##########**",
                "matrixInfo": {
                    "Status": "PendingApproval",
                    "Region": [],
                    "Category": [
                        "77",
                        "81",
                        "72"
                    ],
                    "Business Unit": [],
                    "Material ID": [],
                    "Process Type": []
                }
            }
        ],
        "genericCustomFields": {
            "supplierGenericCustomField": [
                {
                    "name": "XXXXXXXXX",
                    "content": "",
                    "active": true,
                    "timeDeleted": XXXXXXXXXXXXX
                },
                {
                    "name": "XXXXXXXXX",
                    "content": "",
                    "active": true,
                    "timeDeleted": XXXXXXXXX
                }
            ],
            "businessPartnerGenericCustomField": [],
            "companyCodeGenericCustomField": {},
            "bankInfoGenericCustomField": {}
        }
    },
    {
        "count": 1
    }
]

2- Get the workspace and questionnaire

https://mn2.openapi.ariba.com/api/supplierdatapagination/v4/prod/vendors/{**THE_VENDOR_ID**}/workspaces/{**WORKSPACE_ID**}/questionnaires/{**QUESTIONNAIRE_DOC_ID**}/qna

curl --request GET \
  --url 'https://mn2.openapi.ariba.com/api/supplierdatapagination/v4/prod/vendors/{VENDIR_ID}/workspaces/{WORKSPACE_ID}/questionnaires/{QUESTIONNAIRE_ID}/qna?realm={YOUR_REALM}&%24count=true' \
  --header 'Authorization: Bearer {BEARER_TOKEN}' \
  --header 'Content-Type: application/json' \
  --header 'apiKey: {APPLICATION_API_KEY}' \

This should render the questions and answers together.

Upvotes: 0

Lalith Kumar Nimmala
Lalith Kumar Nimmala

Reputation: 11

SAP Ariba now provides REST APIs to extract Supplier Data including Registration, Qualification questionnaires, Risk data, etc. You may refer to this link https://help.sap.com/docs/ariba-apis/supplier-data-api/update-of-questionnaire-using-supplier-data-api?locale=en-US

As of May 2024, this is a free service offered to all SAP Ariba customers and the data retrieved will be specific to the customer's SAP Ariba instance.

Upvotes: 0

Stan Utevski
Stan Utevski

Reputation: 592

I don't know about SAP products, as for RSA ARCHER you can register with RSA Archer Community portal and download Archer API documentation with API samples. You can register there as long as you have access to Archer license key. You can get it on the server where your Archer instance is running from Archer Control Panel. Assuming you can extract data from SAP in CSV/TXT/XML format, then you can use either Archer data feed or Archer API to create/update records in Archer.

I hope someone will help you with SAP. Documentation for Archer API is accessible from RSA. Ask you Archer admin for license key and you can get it.

Good luck!

Upvotes: 1

Related Questions