Hi Team,
We are trying to automate the data import process in every page (for every data models) of Creatio, instead of manually selecting and importing the excel data into creatio. Is this possible in creatio? If possible to automate what would be the requirements ? Please let me know.
Like
Hello,
You can try to start developing a REST integration that will access the same endpoints in the Creatio product where requests go during manual import, namely:
0/rest/FileImportTemplateService/ForceCleanAppliedImportTemplateId
0/rest/FileImportUploadFileService/SaveFile?fileapi17467455643975&importSessionId=06eba730-0918-a0cf-7261-2672023f3ab8&entitySchemaUId=16be3651-8fe2-4159-8dd0-a803d4683dd3&entitySchemaName=FileImportParameters&isOtherObject=true&fileId=06eba730-0918-a0cf-7261-2672023f3ab8&totalFileLength=2934&mimeType=application%2Fvnd.openxmlformats-officedocument.spreadsheetml.sheet&columnName=FileData&fileName=%D0%BA%D0%BE%D0%BD%D1%82%D0%B0%D0%BA%D1%82_09_05_2025_2_06.xlsx&parentColumnName=Id&parentColumnValue=06eba730-0918-a0cf-7261-2672023f3ab8
0/rest/FileImportUploadFileService/CheckIsFileValid
0/rest/FileImportService/SetFileInfo
0/rest/FileImportTemplateService/ApplyImportTemplate
0/rest/FileImportService/GetColumnsMappingParameters
0/rest/FileImportService/SetColumnsMappingParameters
0/rest/FileImportTemplateService/GetImportTemplateId
0/rest/FileImportValidationService/Validate
0/rest/FileImportService/Import - start of the import
0/rest/FileImportService/GetImportSessionInfo
Check the request body for each call, expected and unexpected (exceptions) responses from the server.
Thank you.
What's the use case for Excel files as a source? Can you just use the Data Service or OData APIs instead? Or perhaps even webhooks?
Integrations & API | Creatio Academy