ServiceNow - Auto Import CSV/Excel File

No video

ServiceNow - Auto Import CSV/Excel File

Рет қаралды 6,975

Күн бұрын

Using MID Server and PowerShell to automatically load data from share folder with CSV/Excel File through Data Source, Import Set and Transform Map.
You can find the code in the ServiceNow - Community:
community.serv...

Пікірлер: 18

@ChrisUSC84 3 ай бұрын

Can you elaborate on removing the old attachments in the data set via flow designer?

@mary171117 Жыл бұрын

Muchas gracias Oscar!

@amansingh-ri8ur 3 ай бұрын

My ecc_queue record is in processing state and not getting processed.

@Vijayqjsn132 5 ай бұрын

i some requirement i want get multipel file for sharepoint to servicenow through mid server is it possible to what will be you suggestion for that

@pavelsulek4218 Жыл бұрын

Thank youuuuuuuu Oscar !

@oslovanet Жыл бұрын

My pleasure!!

@federicamerola5762 Жыл бұрын

Hi Oscar. One question: the file you upload in the datasource is in your pc right? If I wanted to upload a file that is in the MID server how should I do it? Thanks in advance the answer.

@oslovanet Жыл бұрын

In this particular example the file is in the same Windows box where I have the MID Server installed

@ankushgupta1987 Жыл бұрын

Hi Oscar! I have used powershell to create data source directly I am able to do that in my isstance but it’s failing on clients instance. I am geeting authorisation error though username password is correct any idea why I am seeing authentication error

@shilpisharma9486 Жыл бұрын

HI Oscar, Thanks for this detailed explanation I am getting below error in my flow designer execution "Action Status": { "code": 1, "message": "Error: Flow Designer; line 4

@oslovanet Жыл бұрын

Check the permissions of the account you're using to run the PowerShell script.

@digvijaythakur5927 Жыл бұрын

How can we pull multiple files and file names are dynamically getting created in the mid server.

@oslovanet Жыл бұрын

With PowerShell you could read the entire folder directory to pull the names of the files, then iterate over each file to send it to the data sources.