Strategic Software Consultant

I'm the partner of choice for many of the world's leading enterprises. I help businesses elevate their value through solution discovery, software development, design, QA, and consultancy services. As your Strategic Software Consultant, I work across many technology products and delivery teams. The scope of technology is broad, and it is my job to understand how your technology applications holistically support and connect to create a sustainable technology ecosystem. The ecosystem of technologies may span to 3rd party applications, in-house developed solutions, business intelligence, data integrations, and of course, SaaS applications.

Oracle Certified Specialist
B2B Sales & Service REST API Oracle B2B Sales & Service Oracle Incentive Compensation

Oracle B2B File Import Activity Using REST API

https://docs.oracle.com/en/cloud/saas/sales/21d/faaps/op-crmrestapi-resources-11.13.18.05-importactivities-post.html

Oracle Content Server (UCM) URL: https://<pod-name>/cs

Oracle Content Server REST API endpoint: https://<pod-name>/resources/latest/erpintegrations

https://docs.oracle.com/en/cloud/saas/financials/21d/farfa/op-erpintegrations-post.html

https://docs.oracle.com/en/cloud/saas/sales/21d/faaps/op-crmrestapi-resources-11.13.18.05-importactivities-importactivityid-child-datafiles-post.html

Upload File

Endpoint: https:///fscmRestApi/resources/11.13.18.05/erpintegrations

Sample Request

{
  "OperationName":"uploadFileToUCM",
  "DocumentAccount":"ic$/incentiveCompensationTransaction$/import$",
  "ContentType":"txt",
  "FileName":"aTest2.csv",
   "DocumentContent":"VHJhbnNhY3Rpb25UeXBlLEF0dHJpYnV0ZU51bWJlcjMsQXR0cmlidXRlTnVtYmVyMixJbnZvaWNlRGF0ZSxJbnZvaWNlTnVtYmVyLEF0dHJpYnV0ZTM0LFNvdXJjZUV2ZW50RGF0ZSxBdHRyaWJ1dGVOdW1iZXI0LEF0dHJpYnV0ZU51bWJlcjUsVHJhbnNhY3Rpb25BbXRTb3VyY2VDdXJyLFRyYW5zYWN0aW9uUXR5LFNvdXJjZUN1cnJlbmN5Q29kZSxBdHRyaWJ1dGUyLEF0dHJpYnV0ZTMsQXR0cmlidXRlNSxBdHRyaWJ1dGU2LEF0dHJpYnV0ZTM1LEF0dHJpYnV0ZTcsQXR0cmlidXRlOCxBdHRyaWJ1dGUxNCxBdHRyaWJ1dGU0LFRlcnJOYW1lLEF0dHJpYnV0ZTE1LEF0dHJpYnV0ZTksQXR0cmlidXRlMzAsQXR0cmlidXRlMTAsQXR0cmlidXRlMzEsQXR0cmlidXRlMTEsQXR0cmlidXRlMjEsQXR0cmlidXRlMjIsQXR0cmlidXRlMjMsQXR0cmlidXRlMjQsQXR0cmlidXRlMjUsQXR0cmlidXRlMTksQXR0cmlidXRlMjAsQXR0cmlidXRlMTIsQXR0cmlidXRlMTMsQXR0cmlidXRlMzMsQnVzaW5lc3NVbml0TmFtZSxTb3VyY2VCdXNpbmVzc1VuaXROYW1lLFByb2Nlc3NDb2RlLEF0dHJpYnV0ZTI4LEF0dHJpYnV0ZTE3LEF0dHJpYnV0ZTE2LEF0dHJpYnV0ZTM2LEF0dHJpYnV0ZTEsQXR0cmlidXRlMjksU291cmNlVHJ4TnVtYmVyLFBhcnRpY2lwYW50SUQKSU5WT0lDRSwyMDIyLDMsMTAvMTQvMjAyMSwxNjQyNjkyNywsMTAvMTQvMjAyMSw2MzAsMCw2MzAsNTAsVVNELFNNX1VTX09VLFVTIC0gQ3JpdGljYWwgQ2FyZSwxMDAwMSwwMSAtIEVhc3QgWm9uZSwiU29sbGksIFZpY3RvciIsMTMwMTIsMDIgLSBQZW5uLVlvcmssIkpvaG1hbm4sIEt1cnRpcyIsMTAxMjAsMDIgLSBWQSAtIDAyLCJSaWNoYXJkcywgU2NvdHQiLFJPQ0hFU1RFUiBHRU5FUkFMIEhPU1BJVEFMLDUzNzAwLDA1MzcwMCAtIFJPQ0hFU1RFUiBHRU5FUkFMIEhPU1BJVEFMLDUxNzc1LDA1MzcwMCAtIFJPQ0hFU1RFUiBHRU5FUkFMIEhPU1BJVEFMICg1MTc3NSksQ2FyZGlvIFRob3JhY2ljLFByZXNzdXJlIE1vbml0b3JpbmcsRElTUCBQcmVzc3VyZSBCYWdzLENsZWFyIEN1ZmZzIChEIEZ1c29ycyksQ2xlYXIgQ3VmZnMgKEQgRnVzb3JzKSxNWDQ3MDUsTVg0NzA1IC0gQ0xFQVItQ1VGRkA1MDBNTCBQUkVTU1VSRSBJTkZVU09SICAgICAxMC9DQSxST0NIRVNURVIgR0VORVJBTCBIT1NQSVRBTCwwNTM3MDAgLSBST0NIRVNURVIgR0VORVJBTCBIT1NQSVRBTCwwNTM3MDAgLSBST0NIRVNURVIgR0VORVJBTCBIT1NQSVRBTCAoNTE3NzUpLFNNX1VTX09VIEJVLFNNX1VTX09VIEJVLENDUkVDLFJPQ0hFU1RFUiBSRUdJT05BTCBIRUFMVEggU1lTVEVNLDI0MTk5LE9QRU4sVVMgLSBTVFJBVEVHSUMgQUNDVFMgLSBBVlAgVU5BU1NJR05FRCBURVJSSVRPUlksQlVDS0VUIDIsQlVDS0VUIDIsMTY0MjY5Mjc6NTE3NzU6TVg0NzA1LDNFKzE0CklOVk9JQ0UsMjAyMiwzLDEwLzE0LzIwMjEsMTY0MjY5MjgsLDEwLzE0LzIwMjEsMTgyNywwLDE4MjcuMzYsMTkyLFVTRCxTTV9VU19PVSxVUyAtIENyaXRpY2FsIENhcmUsMTEwMDIsMDIgLSBDZW50cmFsIFpvbmUsIlNwYXR6LCBSeWFuIiwxMTAzMCwwOSAtIE1pZFdlc3QsIkdpb3Zhbm5pbmksIE1pY2hhZWwiLDExMzA5LDA5IC0gVkFWQyAtIDA3LCJKZW5zZW4sIEFsZXgiLDA2MDAxMSAtIFNUIExVS0VTIFJFR0lPTkFMIE1FRElDQUwgQ0VOVEVSLTA2MDAxMSw2MDAxMSwwNjAwMTEgLSBTVCBMVUtFUyBSRUdJT05BTCBNRURJQ0FMIENFTlRFUi0wNjAwMTEsNTQ2OTQsMDYwMDExIC0gU1RMVUtFJ1MgUkVHIE1FRElDQUwgQ0VOVEVSICg1NDY5NCksQW1idWxhdG9yeSBJbmZ1c2lvbixBbWJ1bGF0b3J5IFB1bXAgRGlzcG9zYmxzLENBREQgRGlzcG9zYWJsZXMsQ0FERCBNZWRpY2F0aW9uIENhc3NldHRlcywxMDBtbCBFcGlkIENhc3NldHRlcyBDQURELDIxLTczMDAtMjQsIjIxLTczMDAtMjQgLSBSRVNFUlZPSVIsIENBU1NFVFRFLCAxMDBNTCwgRlMsIFlFTExPVyAgICAgMTIvQlgiLDA2MDAxMSAtIFNUIExVS0VTIFJFR0lPTkFMIE1FRElDQUwgQ0VOVEVSLTA2MDAxMSwwNjAwMTEgLSBTVCBMVUtFUyBSRUdJT05BTCBNRURJQ0FMIENFTlRFUi0wNjAwMTEsMDYwMDExIC0gU1RMVUtFJ1MgUkVHIE1FRElDQUwgQ0VOVEVSICg1NDY5NCksU01fVVNfT1UgQlUsU01fVVNfT1UgQlUsQ0NSRUMsTm9uSFNNLE5vbkhTTSxOb25IU00sTm9uSFNNLEJVQ0tFVCAyLE5vbkhTTSwxNjQyNjkyODo1NDY5NDoyMS03MzAwLTI0LDNFKzE0CklOVk9JQ0UsMjAyMiwzLDEwLzE0LzIwMjEsMTY0MjY5MzgsLDEwLzE0LzIwMjEsNDEzLDAsNDEyLjg4LDIsVVNELFNNX1VTX09VLFVTIC0gQ3JpdGljYWwgQ2FyZSwxMDAwMSwwMSAtIEVhc3QgWm9uZSwiU29sbGksIFZpY3RvciIsMTMwMTIsMDIgLSBQZW5uLVlvcmssIkpvaG1hbm4sIEt1cnRpcyIsMTEzMDcsMDIgLSBWQyAtIDA1LCJCcm93biwgQW1hbmRhIiw4OTAyMDUgLSBQRU5OIFNUQVRFIEhFQUxUSCAtIEhBTVBERU4gTUVESUNBTCBDRU5URVIsODkwMjA1LDg5MDIwNSAtIFBFTk4gU1RBVEUgSEVBTFRIIC0gSEFNUERFTiBNRURJQ0FMIENFTlRFUiwxNDg0NDM2LDg5MDIwNSAtIFBFTk4gU1RBVEUgSEVBTFRIIC0gSEFNUERFTiBNRURJQ0FMIENFTlRFUiAoMTQ4NDQzNiksVHJhY2hlb3N0b215LFNpbGljb25lIFRyYWNoZW9zdG9teSBUdWJlcyxESVNQIEJpdm9uYSBORU8vUEVEIFRyYWNoZW9zdG9teSBUdWJlcyxOL1AgRmxleHRlbmQsVFRTIE5lbyBGbGV4dGVuZCBTdHJhaWdodCBOZWNrLDY3TkZQUzM1LDY3TkZQUzM1IC0gTkVPTkFUQUwgVFJBQ0hFT1NUT01ZIFRVQkUgMy41IFRUUyBGTEVYVEVORCBTVFJBSUdIVCBGTEFOR0UgICAgIDEvRUEsODkwMjA1IC0gUEVOTiBTVEFURSBIRUFMVEggLSBIQU1QREVOIE1FRElDQUwgQ0VOVEVSLDg5MDIwNSAtIFBFTk4gU1RBVEUgSEVBTFRIIC0gSEFNUERFTiBNRURJQ0FMIENFTlRFUiw4OTAyMDUgLSBQRU5OIFNUQVRFIEhFQUxUSCAtIEhBTVBERU4gTUVESUNBTCBDRU5URVIgKDE0ODQ0MzYpLFNNX1VTX09VIEJVLFNNX1VTX09VIEJVLENDUkVDLE5vbkhTTSxOb25IU00sTm9uSFNNLE5vbkhTTSxCVUNLRVQgMSxOb25IU00sMTY0MjY5Mzg6MTQ4NDQzNjo2N05GUFMzNSwzRSsxNApJTlZPSUNFLDIwMjIsMywxMC8xNC8yMDIxLDE2NDI2OTM5LCwxMC8xNC8yMDIxLDg0LDAsODMuODEsMTAsVVNELFNNX1VTX09VLFVTIC0gQ3JpdGljYWwgQ2FyZSwxMDAwMSwwMSAtIEVhc3QgWm9uZSwiU29sbGksIFZpY3RvciIsMTAwMTAsMDMgLSBDYXBpdGFsLCJEb2VobmVyLCBKb2huIiwxMTEwNCwwMyAtIFZDIC0gMDgsIlZhY2Nhcm8tR2xhbmZpZWxkLCBKYW1pZSIsVEhFIFJFQURJTkcgSE9TUElUQUwgJiBNRURJQ0FMIENFTlRFUiw1MjE1MCwwNTIxNTAgLSBUSEUgUkVBRElORyBIT1NQSVRBTCAmIE1FRElDQUwgQ0VOVEVSLDIyNzc2MSwwNTIxNTAgLSBSRUFESU5HIEhPU1BJVEFMICYgTUVESUNBTCBDRU5URVIgKDIyNzc2MSksVHJhY2hlb3N0b215LFBWQyBUcmFjaGVvc3RvbXkgVHViZXMsRElTUCBQZXJjdXRhbmVvdXMgKFBDVC9QRFQpIGFuZCBJQyxVbmlwZXJjIChJbm4gQ2FubiksMTAwLzg5MCwxMDAvODkwLzA3MENaLCIxMDAvODkwLzA3MENaIC0gUkVQTEFDRU1FTlQgSU5ORVIgQ0FOTlVMQSBGT1IgVU5JUEVSQyBBREpVU1RBQkxFIEZMQU5HRSBUUkFDSEVPU1RPTVkgVFVCRSwiLFRIRSBSRUFESU5HIEhPU1BJVEFMICYgTUVESUNBTCBDRU5URVIsMDUyMTUwIC0gVEhFIFJFQURJTkcgSE9TUElUQUwgJiBNRURJQ0FMIENFTlRFUiwwNTIxNTAgLSBSRUFESU5HIEhPU1BJVEFMICYgTUVESUNBTCBDRU5URVIgKDIyNzc2MSksU01fVVNfT1UgQlUsU01fVVNfT1UgQlUsQ0NSRUMsQUxMU1BJUkUsMjQxMTIsIkVsYmVydCwgRGFuIixVUyAtIFNBRSAtIENlbnRyYWwgLSBHcmVhdCBMYWtlcyxCVUNLRVQgMSxCVUNLRVQgMSwxNjQyNjkzOToyMjc3NjE6MTAwLzg5MC8wNzBDWiwzRSsxNApJTlZPSUNFLDIwMjIsMywxMC8xNC8yMDIxLDE2NDI2OTQwLCwxMC8xNC8yMDIxLDU5MiwwLDU5MS41MiwyMCxVU0QsU01fVVNfT1UsVVMgLSBDcml0aWNhbCBDYXJlLDExMDAyLDAyIC0gQ2VudHJhbCBab25lLCJTcGF0eiwgUnlhbiIsMTMwMTAsMDcgLSBOYXNodmlsbGUsIkV2YW4sIFN0ZXZlIiwxMTMwMSwwNyAtIFZBVkMgLSAwMiwiRGF2aXMsIFRob21hcyIsMDMwNjgxIC0gU1QgRlJBTkNJUyBIT1NQSVRBTC0wMzA2ODEsMzA2ODEsMDMwNjgxIC0gU1QgRlJBTkNJUyBIT1NQSVRBTC0wMzA2ODEsNDE5MzUsMDMwNjgxIC0gS0VORFJJQ0sgTUVNT1JJQUwgSE9TUElUQUwgKDQxOTM1KSxQYWluIE1hbmFnZW1lbnQsRXBpZHVyYWwsRXBpZHVyYWwgQ29udGludW91cyxFcGlkdXJhbCBDb250aW51b3VzLEVwaWQgQ29udCBQcm9jIFRyYXlzL0tpdHMsMzA5Ny0yMCwzMDk3LTIwIC0gQ09OVElOVU9VUyBFUElEKEVERCkgICUgMTAvQ0EsMDMwNjgxIC0gU1QgRlJBTkNJUyBIT1NQSVRBTC0wMzA2ODEsMDMwNjgxIC0gU1QgRlJBTkNJUyBIT1NQSVRBTC0wMzA2ODEsMDMwNjgxIC0gS0VORFJJQ0sgTUVNT1JJQUwgSE9TUElUQUwgKDQxOTM1KSxTTV9VU19PVSBCVSxTTV9VU19PVSBCVSxDQ1JFQyxOb25IU00sTm9uSFNNLE5vbkhTTSxOb25IU00sQlVDS0VUIDIsTm9uSFNNLDE2NDI2OTQwOjQxOTM1OjMwOTctMjAsM0UrMTQKSU5WT0lDRSwyMDIyLDMsMTAvMTQvMjAyMSwxNjQyNjk1NCwsMTAvMTQvMjAyMSwyNjUsMCwyNjUsMSxVU0QsU01fVVNfT1UsVVMgLSBDcml0aWNhbCBDYXJlLDEwMDAyLDAzIC0gV2VzdCBab25lLCJUYWxsZXksIEp1c3RpbiIsMTAwMzAsMTEgLSBOb3J0aCBUZXhhcywiUm9tZXJvLUdlaWdlciwgTG9yaW5hIiwxMTQwMSwxMSAtIFZDIC0gMDQsIk1hcnNoYWxsLCBOZWlsIiwwMTE1NTIgLSBDT09LIENISUxEUkVOJ1MgTUVESUNBTCBDRU5URVIsMTE1NTIsMDExNTUyIC0gQ09PSyBDSElMRFJFTidTIE1FRElDQUwgQ0VOVEVSLDE0NTcwNjcsMDExNTUyIC0gQ09PSyBDSElMRFJFTidTIE1FRElDQUwgQ0VOVEVSICgxNDU3MDY3KSxUcmFjaGVvc3RvbXksU2lsaWNvbmUgVHJhY2hlb3N0b215IFR1YmVzLERJU1AgQml2b25hIFRyYWNoZW9zdG9teSBUdWJlcyxCaXZvbmEgQ3VzdG9tIExhYixDdXN0b20gQml2b25hIFR1YmVzLFNVMjBKTjU1TkdHODc4TixTVTIwSk41NU5HRzg3OE4gLSBDVVNUT00gNS41IEZJWEVEIENVRkZMRVNTIE5TICsxL0VBLDAxMTU1MiAtIENPT0sgQ0hJTERSRU4nUyBNRURJQ0FMIENFTlRFUiwwMTE1NTIgLSBDT09LIENISUxEUkVOJ1MgTUVESUNBTCBDRU5URVIsMDExNTUyIC0gQ09PSyBDSElMRFJFTidTIE1FRElDQUwgQ0VOVEVSICgxNDU3MDY3KSxTTV9VU19PVSBCVSxTTV9VU19PVSBCVSxDQ1JFQyxDSEEsMjQyMzgsIkNhcnRlciwgTmFuY3llIixVUyAtIFNBRSAtIENlbnRyYWwgLSBOYXNodmlsbGUsQlVDS0VUIDEsQlVDS0VUIDEsMTY0MjY5NTQ6MTQ1NzA2NzpTVTIwSk41NU5HRzg3OE4sM0UrMTQKSU5WT0lDRSwyMDIyLDMsMTAvMTQvMjAyMSwxNjQyNjk1NywsMTAvMTQvMjAyMSwyMzIsMCwyMzEuNTMsMjAwLFVTRCxTTV9VU19PVSxVUyAtIENyaXRpY2FsIENhcmUsMTAwMDEsMDEgLSBFYXN0IFpvbmUsIlNvbGxpLCBWaWN0b3IiLDEwMDEwLDAzIC0gQ2FwaXRhbCwiRG9laG5lciwgSm9obiIsMTAxMDEsMDMgLSBWQSAtIDAyLCJPcGVuLCAxMDEwMSIsQ0FSSUxJT04gTUFURVJJQUxTIE1BTkFHRU1FTlQsNTM0MDAsMDUzNDAwIC0gQ0FSSUxJT04gTUFURVJJQUxTIE1BTkFHRU1FTlQsNTE3MDQsMDUzNDAwIC0gUk9BTk9LRSBNRU1PUklBTCBIT1NQSVRBTCAoNTE3MDQpLFBJVkMsQ29udmVudGlvbmFsIENhdGhldGVycyxDb252ZW50aW9uYWwgQ2F0aGV0ZXIgQWxsLEpFTENPIEZFUCxKRUxDTyBGRVAgU3RyYWlnaHQsNDA1OTExLDQwNTkxMSAtIDIwRyBYIDEgMy80IEpFTENPIENBVEhFVEVSIFJBRElPUEFRVUUgICAgIDIwMC9DQSxDQVJJTElPTiBNQVRFUklBTFMgTUFOQUdFTUVOVCwwNTM0MDAgLSBDQVJJTElPTiBNQVRFUklBTFMgTUFOQUdFTUVOVCwwNTM0MDAgLSBST0FOT0tFIE1FTU9SSUFMIEhPU1BJVEFMICg1MTcwNCksU01fVVNfT1UgQlUsU01fVVNfT1UgQlUsQ0NSRUMsQ0FSSUxJT04gQ0xJTklDLDI0MTIyLCJCYXNzLCBSZWJlY2NhIixVUyAtIFNBRSAtIEVhc3QgLSBDYXJvbGluYXMsQlVDS0VUIDIsQlVDS0VUIDIsMTY0MjY5NTc6NTE3MDQ6NDA1OTExLAo="
}

Import Activity

Endpoint: https://<instance>/crmRestApi/resources/11.13.18.05/importActivities

{
    "Name": "Craig_REST_API_Test_4",
    "ObjectCode": "IncentiveTransaction",
    "DecimalSeparator": ".",
    "DateFormat": "ORA_ZCA_US_FORMAT",
    "ImportMode": "CREATE_RECORD",
    "TimestampFormat": "ORA_ZCA_US_FORMAT",
    "FileEncoding": "ORA_ZCA_UTF8_ENCODING",
    "Delimiter": "COMMA_DELIMITER",
    "Schedule": "ONE_TIME_IMMEDIATE",
    "Activate": "YES",
    "HighVolume": "YES",
    "DataFiles": [
        {
            "InputFileContentId": "UCMFA01250338"
        }
    ]
}

Open Question

How to get the InputFileContentId from the Document ID in the Upload File Response?

Leave a comment

Your email address will not be published.