Auto-update for core_country system table

simonezini · ‎06-30-2022

Hi,
is it possible to automatically update the system table "core_country"? It's the table that contains a list of countries, with ISO code, IANA suffix and so on.
It seems that on our instance these records haven't been updated since 2014

Thanks
Regards

Greg G3 · ‎04-08-2024

Simone,

I know your question is a bit old, but I hope this helps your or someone else with this; I am on the same quest for this option.

There is a knowledge article from ServiceNow that indicates there are no updates from ServiceNow since 2014, and no plans to do so at this time; it is here: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0781622

The UN numerical codes can be downloaded (manually) from their website:
https://unstats.un.org/unsd/methodology/m49/

https://unstats.un.org/unsd/methodology/m49/overview/

The ISO "country codes" can be found at the ISO website, and there are paid options to download the data, and may be free options as well:

https://www.iso.org/iso-3166-country-codes.html

So while I haven't found official sources from which to automatically sync or download, I hope this provides some useful info.

Spero che quest'informazione l ha aiutato!

View solution in original post

Jaspal Singh · ‎06-30-2022

Hi Simon,

Image is broken.

To answer your question, Yes, it can be updated. However, can you elaborate 'automatically update'. Does this man by any integration or so?

simonezini · ‎06-30-2022

Hi Jaspal,

thanks for your reply. Image is this one:

As you can see, no updates have been made on these records since 2014.

By "automatically update" I mean some external rest APIs called by a scheduled job that daily checks for example for new countries, new names, new codes and so on..

I've found some free apis on internet, I was wondering if ServiceNow has already this type of solution or if we need to use something external or third part

Thanks

Regards

Jaspal Singh · ‎06-30-2022

Yes, it is 2014 & I belive it will be same as created time.

Yes, you can update records using APIs called by scheduled job or independantly. You can also create new records.

Yes, solution has API solutions offered you can simply navigate to System Web Services >> REST >> REST API Explorer & try by selecting table or so.

Also, you can use Scripted SOAP, REST Messages. ServiceNow DOC has all of it in detail.

simonezini · ‎07-05-2022

Hi Jaspal,

thanks for your reply.

I know I can call external API to update these records, what I wanted to know is if there are some ServiceNow APIs that I can call and that give me all of these data. For what I've found, this is one of the services I'm talking about: https://restcountries.com

Regards

Simone