CSV/Excel Data imports via HTTPS method

Narendra7 · ‎08-07-2018

Hi All,

I have read that we can import https files data into Servicenow from Data source. However, when I try to Load either https/http, I keep on getting Null records. Am I missing something here? Could someone please point me in right direction.

When I click on Test Load 20 Records and Load All records from Related Links, I am getting Null Records to the Import Set table.

Status showing Loaded, however records are zero.

Why it is behaving like this ?

Thanks,

Narendra

Narendra7 · ‎08-08-2018

Thanks Mark!! I figured out the problem. The problem is with file retrieval method. It is SFTP method not https method. After I change the retrieval method from https to sftp it worked for me. My initial understanding was wrong. Thanks for your support .

View solution in original post

Mark Stanger · ‎08-07-2018

Hmm. The only other thing I can think of is that your https data source is restricting access somehow. I wonder if you could try to access that file with your web browser when you're not connected to the same network as the https server?

Narendra7 · ‎08-07-2018

I am able to access that https webserver from Public network.

Do you think from ServiceNow do we need to enable any PORT ? if Yes, to whom I need to contact.

Thanks,

Narendra

Mark Stanger · ‎08-07-2018

I wouldn't think so for https. Either way you might be best off contacting customer support at this point. Please let me know what you find.

Narendra7 · ‎08-07-2018

Sure, thanks Mark for your support and suggestions.

Regards,

Narendra

Mark Stanger · ‎08-07-2018

This may not help either, but I noticed a similar issue here...with a possible fix from John Andersen.

https://community.servicenow.com/community?id=community_question&sys_id=a48e4b21dbdcdbc01dcaf3231f961911