API-Import not working with Error "Action with NOFAIL Failed."

Question

Hello everyone, so I created a Powershell Script to get the M365 Endpoint URLs and IP-Ranges to Import them as an Object into the Firewall. But when I try to Import it it only throws an Error that the file format is not supported. Here is the Output of the csc custom debug: MESSAGE Mar 20 08:58:08Z [worker:7654]: {"request":{"method":"opcode","name":"upload_text_import_file","version":"1.10","type":"json","length":396,"data":{ "___serverport": 4444, "importtype": "2", "___component": "GUI", "transactionid": "1523", "mode": 727, "currentlyloggedinuserid": 3, "importfile": "\/sdisk\/upload\/db14c0b3-ea81-4470-b753-375585fdc040.tar", "APIVersion": "2000.1", "___serverprotocol": "HTTP", "___username": "admin", "___meta": { "sessionType": 1 }, "___serverip": "xxx.xxx.xxx.xxx", "currentlyloggedinuserip": "xxx.xxx.xxx.xxx" }}} DEBUG Mar 20 08:58:08Z [worker:7654]: ### insert_uuid: hdr: len=363 content=0 method=0 name=upload_text_import_file DEBUG Mar 20 08:58:08Z [upload_text_import_file:7654]: init_db_handle_pl: Initializing DBI DB handle INFO Mar 20 08:58:08Z [upload_text_import_file:7654]: creating json object INFO Mar 20 08:58:08Z [upload_text_import_file:7654]: do_get: SET_Maintenance DEBUG Mar 20 08:58:08Z [upload_text_import_file:7654]: do_prep_query: PREPSTMT without ARGS: select value from tblconfiguration where key='ips_cat_version' DEBUG Mar 20 08:58:08Z [upload_text_import_file:7654]: execute_prepare_query: Initializing database for nobody:corporate INFO Mar 20 08:58:08Z [upload_text_import_file:7654]: CSC::PREPSTMT : Create new connection. DEBUG Mar 20 08:58:08Z [upload_text_import_file:7654]: get_txid:Transaction ID: 16987 DEBUG Mar 20 08:58:08Z [upload_text_import_file:7654]: do_prep_query: PREPSTMT: 'select value from tblconfiguration where key='ips_cat_version'' DEBUG Mar 20 08:58:08Z [upload_text_import_file:7654]: do_prep_query: PREPSTMT without ARGS: select count(*)::INT as count from tblidprules DEBUG Mar 20 08:58:08Z [upload_text_import_file:7654]: execute_prepare_query: Initializing database for nobody:signature INFO Mar 20 08:58:08Z [upload_text_import_file:7654]: CSC::PREPSTMT : Create new connection. DEBUG Mar 20 08:58:08Z [upload_text_import_file:7654]: get_txid:Transaction ID: 1380 DEBUG Mar 20 08:58:08Z [upload_text_import_file:7654]: do_prep_query: PREPSTMT: 'select count(*)::INT as count from tblidprules' INFO Mar 20 08:58:08Z [upload_text_import_file:7654]: do_at: (clean_importfiles:delete) ERROR Mar 20 08:58:08Z [timer:5904]: delete_sched_node: timer clean_importfiles do not exist DEBUG Mar 20 08:58:08Z [upload_text_import_file:7654]: log_exec: Command: /bin/mv $importFile /sdisk/APIImport.tar INFO Mar 20 08:58:08Z [upload_text_import_file:7654]: csc_execve: Child exited with status 0 INFO Mar 20 08:58:08Z [upload_text_import_file:7654]: create_act_out_perl_obj: varname=out INFO Mar 20 08:58:08Z [upload_text_import_file:7654]: create_act_out_perl_obj: out.status=0 DEBUG Mar 20 08:58:08Z [upload_text_import_file:7654]: log_exec: Command: /usr/bin/crimport -s -i /sdisk/APIImport.tar -a ?? -v /_conf/csc/IOMappingFiles/ -l /log/apiparser.log -C ?? -R ?? $CURR_API_DISPLAY_VERSION $ips_cat_corp_ver $ips_rules_cnt ERROR Mar 20 08:58:08Z [upload_text_import_file:7654]: csc_execve: Child exited with status 1 ERROR Mar 20 08:58:08Z [upload_text_import_file:7654]: log_exec: Failed Command: /usr/bin/crimport -s -i /sdisk/APIImport.tar -a ?? -v /_conf/csc/IOMappingFiles/ -l /log/apiparser.log -C ?? -R ?? $CURR_API_DISPLAY_VERSION $ips_cat_corp_ver $ips_rules_cnt INFO Mar 20 08:58:08Z [upload_text_import_file:7654]: create_act_out_perl_obj: varname=out INFO Mar 20 08:58:08Z [upload_text_import_file:7654]: create_act_out_perl_obj: out.status=1 WARNING Mar 20 08:58:08Z [upload_text_import_file:7654]: Action with NOFAIL Failed. DEBUG Mar 20 08:58:08Z [upload_text_import_file:7654]: destroy_db_handle_pl: Destroying DBI DB handle. DEBUG Mar 20 08:58:08Z [upload_text_import_file:7654]: destroy_db_handle_pl: Destroying DBI DB handle. MESSAGE Mar 20 08:58:08Z [upload_text_import_file:7654]: opcode 'upload_text_import_file': time taken: 0.348345157 seconds with return status: '500' DEBUG Mar 20 08:58:08Z [worker:7654]: # OPCODE Exited: 'upload_text_import_file' with Status: '500' I have the suspicion that there is a n error with the xml-file but it does not show mit in the log where the error is? Here is my current xml-file: M365_net_104.146.128.0 IPv4 Network 104.146.128.0 255.255.128.0 M365_net_104.47.0.0 IPv4 Network 104.47.0.0 255.255.128.0 M365_net_13.107.128.0 IPv4 Network 13.107.128.0 255.255.252.0 M365_net_13.107.136.0 IPv4 Network 13.107.136.0 255.255.252.0 M365_h_13.107.140.6 IPv4 IP 13.107.140.6 M365_net_13.107.18.10 IPv4 Network 13.107.18.10 255.255.255.254 M365_h_13.107.18.15 IPv4 IP 13.107.18.15 M365_net_13.107.6.152 IPv4 Network 13.107.6.152 255.255.255.254 M365_h_13.107.6.171 IPv4 IP 13.107.6.171 M365_h_13.107.6.192 IPv4 IP 13.107.6.192 M365_net_13.107.64.0 IPv4 Network 13.107.64.0 255.255.192.0 M365_h_13.107.9.192 IPv4 IP 13.107.9.192 M365_h_131.253.33.215 IPv4 IP 131.253.33.215 M365_net_132.245.0.0 IPv4 Network 132.245.0.0 255.255.0.0 M365_net_150.171.32.0 IPv4 Network 150.171.32.0 255.255.252.0 M365_net_150.171.40.0 IPv4 Network 150.171.40.0 255.255.252.0 M365_net_20.190.128.0 IPv4 Network 20.190.128.0 255.255.192.0 M365_net_20.20.32.0 IPv4 Network 20.20.32.0 255.255.224.0 M365_net_20.231.128.0 IPv4 Network 20.231.128.0 255.255.224.0 M365_h_204.79.197.215 IPv4 IP 204.79.197.215 M365_net_23.103.160.0 IPv4 Network 23.103.160.0 255.255.240.0 M365_net_2603:1006:: IPv6 Network 2603:1006:: 40 M365_net_2603:1006:1400:: IPv6 Network 2603:1006:1400:: 40 M365_net_2603:1006:2000:: IPv6 Network 2603:1006:2000:: 48 M365_net_2603:1007:200:: IPv6 Network 2603:1007:200:: 48 M365_net_2603:1016:: IPv6 Network 2603:1016:: 36 M365_net_2603:1016:1400:: IPv6 Network 2603:1016:1400:: 48 M365_net_2603:1016:2400:: IPv6 Network 2603:1016:2400:: 40 M365_net_2603:1017:: IPv6 Network 2603:1017:: 48 M365_net_2603:1026:: IPv6 Network 2603:1026:: 36 M365_net_2603:1026:2400:: IPv6 Network 2603:1026:2400:: 40 M365_net_2603:1026:3000:: IPv6 Network 2603:1026:3000:: 48 M365_net_2603:1027:: IPv6 Network 2603:1027:: 48 M365_net_2603:1027:1:: IPv6 Network 2603:1027:1:: 48 M365_net_2603:1036:: IPv6 Network 2603:1036:: 36 M365_net_2603:1036:2400:: IPv6 Network 2603:1036:2400:: 40 M365_net_2603:1036:3000:: IPv6 Network 2603:1036:3000:: 48 M365_net_2603:1037:: IPv6 Network 2603:1037:: 48 M365_net_2603:1037:1:: IPv6 Network 2603:1037:1:: 48 M365_net_2603:1046:: IPv6 Network 2603:1046:: 36 M365_net_2603:1046:1400:: IPv6 Network 2603:1046:1400:: 40 M365_net_2603:1046:2000:: IPv6 Network 2603:1046:2000:: 48 M365_net_2603:1047:: IPv6 Network 2603:1047:: 48 M365_net_2603:1047:1:: IPv6 Network 2603:1047:1:: 48 M365_net_2603:1056:: IPv6 Network 2603:1056:: 36 M365_net_2603:1056:1400:: IPv6 Network 2603:1056:1400:: 40 M365_net_2603:1056:2000:: IPv6 Network 2603:1056:2000:: 48 M365_net_2603:1057:: IPv6 Network 2603:1057:: 48 M365_net_2603:1057:2:: IPv6 Network 2603:1057:2:: 48 M365_net_2603:1061:1300:: IPv6 Network 2603:1061:1300:: 40 M365_net_2603:1063:: IPv6 Network 2603:1063:: 38 M365_net_2603:1063:2000:: IPv6 Network 2603:1063:2000:: 38 M365_h_2620:1ec:4::152 IPv6 IP 2620:1ec:4::152 M365_h_2620:1ec:4::153 IPv6 IP 2620:1ec:4::153 M365_h_2620:1ec:4::192 IPv6 IP 2620:1ec:4::192 M365_net_2620:1ec:40:: IPv6 Network 2620:1ec:40:: 42 M365_net_2620:1ec:6:: IPv6 Network 2620:1ec:6:: 48 M365_net_2620:1ec:8f0:: IPv6 Network 2620:1ec:8f0:: 46 M365_net_2620:1ec:8f8:: IPv6 Network 2620:1ec:8f8:: 46 M365_h_2620:1ec:8fc::6 IPv6 IP 2620:1ec:8fc::6 M365_net_2620:1ec:900:: IPv6 Network 2620:1ec:900:: 46 M365_net_2620:1ec:908:: IPv6 Network 2620:1ec:908:: 46 M365_h_2620:1ec:a92::152 IPv6 IP 2620:1ec:a92::152 M365_h_2620:1ec:a92::153 IPv6 IP 2620:1ec:a92::153 M365_h_2620:1ec:a92::171 IPv6 IP 2620:1ec:a92::171 M365_h_2620:1ec:a92::192 IPv6 IP 2620:1ec:a92::192 M365_h_2620:1ec:c::10 IPv6 IP 2620:1ec:c::10 M365_h_2620:1ec:c::11 IPv6 IP 2620:1ec:c::11 M365_h_2620:1ec:c::15 IPv6 IP 2620:1ec:c::15 M365_h_2620:1ec:d::10 IPv6 IP 2620:1ec:d::10 M365_h_2620:1ec:d::11 IPv6 IP 2620:1ec:d::11 M365_h_2a01:111:f100:2000::a83e:3019 IPv6 IP 2a01:111:f100:2000::a83e:3019 M365_h_2a01:111:f100:2002::8975:2d79 IPv6 IP 2a01:111:f100:2002::8975:2d79 M365_h_2a01:111:f100:2002::8975:2da8 IPv6 IP 2a01:111:f100:2002::8975:2da8 M365_h_2a01:111:f100:7000::6fdd:6cd5 IPv6 IP 2a01:111:f100:7000::6fdd:6cd5 M365_h_2a01:111:f100:a004::bfeb:88cf IPv6 IP 2a01:111:f100:a004::bfeb:88cf M365_net_2a01:111:f400:: IPv6 Network 2a01:111:f400:: 48 M365_net_2a01:111:f402:: IPv6 Network 2a01:111:f402:: 48 M365_net_2a01:111:f403:: IPv6 Network 2a01:111:f403:: 48 M365_net_40.104.0.0 IPv4 Network 40.104.0.0 255.254.0.0 M365_net_40.107.0.0 IPv4 Network 40.107.0.0 255.255.0.0 M365_net_40.108.128.0 IPv4 Network 40.108.128.0 255.255.128.0 M365_net_40.126.0.0 IPv4 Network 40.126.0.0 255.255.192.0 M365_net_40.92.0.0 IPv4 Network 40.92.0.0 255.254.0.0 M365_net_40.96.0.0 IPv4 Network 40.96.0.0 255.248.0.0 M365_net_52.100.0.0 IPv4 Network 52.100.0.0 255.252.0.0 M365_net_52.104.0.0 IPv4 Network 52.104.0.0 255.252.0.0 M365_net_52.108.0.0 IPv4 Network 52.108.0.0 255.252.0.0 M365_net_52.112.0.0 IPv4 Network 52.112.0.0 255.252.0.0 M365_net_52.122.0.0 IPv4 Network 52.122.0.0 255.254.0.0 M365_h_52.238.119.141 IPv4 IP 52.238.119.141 M365_h_52.238.78.88 IPv4 IP 52.238.78.88 M365_h_52.244.160.207 IPv4 IP 52.244.160.207 M365_h_52.244.37.168 IPv4 IP 52.244.37.168 M365_net_52.96.0.0 IPv4 Network 52.96.0.0 255.252.0.0 grp_M365_IPv4 All Public IPv4-Addresses from Microsoft M365_net_104.146.128.0 M365_net_104.47.0.0 M365_net_13.107.128.0 M365_net_13.107.136.0 M365_h_13.107.140.6 M365_net_13.107.18.10 M365_h_13.107.18.15 M365_net_13.107.6.152 M365_h_13.107.6.171 M365_h_13.107.6.192 M365_net_13.107.64.0 M365_h_13.107.9.192 M365_h_131.253.33.215 M365_net_132.245.0.0 M365_net_150.171.32.0 M365_net_150.171.40.0 M365_net_20.190.128.0 M365_net_20.20.32.0 M365_net_20.231.128.0 M365_h_204.79.197.215 M365_net_23.103.160.0 M365_net_40.104.0.0 M365_net_40.107.0.0 M365_net_40.108.128.0 M365_net_40.126.0.0 M365_net_40.92.0.0 M365_net_40.96.0.0 M365_net_52.100.0.0 M365_net_52.104.0.0 M365_net_52.108.0.0 M365_net_52.112.0.0 M365_net_52.122.0.0 M365_h_52.238.119.141 M365_h_52.238.78.88 M365_h_52.244.160.207 M365_h_52.244.37.168 M365_net_52.96.0.0 IPv4 grp_M365_IPv6 All Public IPv6-Addresses from Microsoft M365_net_2603:1006:: M365_net_2603:1006:1400:: M365_net_2603:1006:2000:: M365_net_2603:1007:200:: M365_net_2603:1016:: M365_net_2603:1016:1400:: M365_net_2603:1016:2400:: M365_net_2603:1017:: M365_net_2603:1026:: M365_net_2603:1026:2400:: M365_net_2603:1026:3000:: M365_net_2603:1027:: M365_net_2603:1027:1:: M365_net_2603:1036:: M365_net_2603:1036:2400:: M365_net_2603:1036:3000:: M365_net_2603:1037:: M365_net_2603:1037:1:: M365_net_2603:1046:: M365_net_2603:1046:1400:: M365_net_2603:1046:2000:: M365_net_2603:1047:: M365_net_2603:1047:1:: M365_net_2603:1056:: M365_net_2603:1056:1400:: M365_net_2603:1056:2000:: M365_net_2603:1057:: M365_net_2603:1057:2:: M365_net_2603:1061:1300:: M365_net_2603:1063:: M365_net_2603:1063:2000:: M365_h_2620:1ec:4::152 M365_h_2620:1ec:4::153 M365_h_2620:1ec:4::192 M365_net_2620:1ec:40:: M365_net_2620:1ec:6:: M365_net_2620:1ec:8f0:: M365_net_2620:1ec:8f8:: M365_h_2620:1ec:8fc::6 M365_net_2620:1ec:900:: M365_net_2620:1ec:908:: M365_h_2620:1ec:a92::152 M365_h_2620:1ec:a92::153 M365_h_2620:1ec:a92::171 M365_h_2620:1ec:a92::192 M365_h_2620:1ec:c::10 M365_h_2620:1ec:c::11 M365_h_2620:1ec:c::15 M365_h_2620:1ec:d::10 M365_h_2620:1ec:d::11 M365_h_2a01:111:f100:2000::a83e:3019 M365_h_2a01:111:f100:2002::8975:2d79 M365_h_2a01:111:f100:2002::8975:2da8 M365_h_2a01:111:f100:7000::6fdd:6cd5 M365_h_2a01:111:f100:a004::bfeb:88cf M365_net_2a01:111:f400:: M365_net_2a01:111:f402:: M365_net_2a01:111:f403:: IPv6 M365_fqdn_wildcard.aadrm.com *.aadrm.com M365_fqdn_wildcard.acompli.net *.acompli.net M365_fqdn_wildcard.activity.windows.com *.activity.windows.com M365_fqdn_wildcard.appex-rf.msn.com *.appex-rf.msn.com M365_fqdn_wildcard.appex.bing.com *.appex.bing.com M365_fqdn_wildcard.aria.microsoft.com *.aria.microsoft.com M365_fqdn_wildcard.assets-yammer.com *.assets-yammer.com M365_fqdn_wildcard.auth.microsoft.com *.auth.microsoft.com M365_fqdn_wildcard.azure-apim.net *.azure-apim.net M365_fqdn_wildcard.azureedge.net *.azureedge.net M365_fqdn_wildcard.azurerms.com *.azurerms.com M365_fqdn_wildcard.blob.core.windows.net *.blob.core.windows.net M365_fqdn_wildcard.compliance.microsoft.com *.compliance.microsoft.com M365_fqdn_wildcard.cortana.ai *.cortana.ai M365_fqdn_wildcard.entrust.net *.entrust.net M365_fqdn_wildcard.events.data.microsoft.com *.events.data.microsoft.com M365_fqdn_wildcard.flow.microsoft.com *.flow.microsoft.com M365_fqdn_wildcard.geotrust.com *.geotrust.com M365_fqdn_wildcard.hip.live.com *.hip.live.com M365_fqdn_wildcard.informationprotection.azure.com *.informationprotection.azure.com M365_fqdn_wildcard.keydelivery.mediaservices.windows.net *.keydelivery.mediaservices.windows.net M365_fqdn_wildcard.lync.com *.lync.com M365_fqdn_wildcard.mail.protection.outlook.com *.mail.protection.outlook.com M365_fqdn_wildcard.media.azure.net *.media.azure.net M365_fqdn_wildcard.microsoft.com *.microsoft.com M365_fqdn_wildcard.microsoftonline-p.com *.microsoftonline-p.com M365_fqdn_wildcard.microsoftonline.com *.microsoftonline.com M365_fqdn_wildcard.microsoftstream.com *.microsoftstream.com M365_fqdn_wildcard.microsoftusercontent.com *.microsoftusercontent.com M365_fqdn_wildcard.msauth.net *.msauth.net M365_fqdn_wildcard.msauthimages.net *.msauthimages.net M365_fqdn_wildcard.msecnd.net *.msecnd.net M365_fqdn_wildcard.msftauth.net *.msftauth.net M365_fqdn_wildcard.msftauthimages.net *.msftauthimages.net M365_fqdn_wildcard.msftidentity.com *.msftidentity.com M365_fqdn_wildcard.msidentity.com *.msidentity.com M365_fqdn_wildcard.msocdn.com *.msocdn.com M365_fqdn_wildcard.o365weve.com *.o365weve.com M365_fqdn_wildcard.office.com *.office.com M365_fqdn_wildcard.office.net *.office.net M365_fqdn_wildcard.office365.com *.office365.com M365_fqdn_wildcard.officeapps.live.com *.officeapps.live.com M365_fqdn_wildcard.omniroot.com *.omniroot.com M365_fqdn_wildcard.onenote.com *.onenote.com M365_fqdn_wildcard.online.office.com *.online.office.com M365_fqdn_wildcard.onmicrosoft.com *.onmicrosoft.com M365_fqdn_wildcard.outlook.com *.outlook.com M365_fqdn_wildcard.outlookmobile.com *.outlookmobile.com M365_fqdn_wildcard.phonefactor.net *.phonefactor.net M365_fqdn_wildcard.portal.cloudappsecurity.com *.portal.cloudappsecurity.com M365_fqdn_wildcard.powerapps.com *.powerapps.com M365_fqdn_wildcard.powerautomate.com *.powerautomate.com M365_fqdn_wildcard.protection.office.com *.protection.office.com M365_fqdn_wildcard.protection.outlook.com *.protection.outlook.com M365_fqdn_wildcard.public-trust.com *.public-trust.com M365_fqdn_wildcard.search.production.apac.trafficmanager.net *.search.production.apac.trafficmanager.net M365_fqdn_wildcard.search.production.emea.trafficmanager.net *.search.production.emea.trafficmanager.net M365_fqdn_wildcard.search.production.us.trafficmanager.net *.search.production.us.trafficmanager.net M365_fqdn_wildcard.secure.skypeassets.com *.secure.skypeassets.com M365_fqdn_wildcard.security.microsoft.com *.security.microsoft.com M365_fqdn_wildcard.sharepoint.com *.sharepoint.com M365_fqdn_wildcard.sharepointonline.com *.sharepointonline.com M365_fqdn_wildcard.skype.com *.skype.com M365_fqdn_wildcard.streaming.mediaservices.windows.net *.streaming.mediaservices.windows.net M365_fqdn_wildcard.svc.ms *.svc.ms M365_fqdn_wildcard.symcb.com *.symcb.com M365_fqdn_wildcard.symcd.com *.symcd.com M365_fqdn_wildcard.teams.microsoft.com *.teams.microsoft.com M365_fqdn_wildcard.users.storage.live.com *.users.storage.live.com M365_fqdn_wildcard.verisign.com *.verisign.com M365_fqdn_wildcard.verisign.net *.verisign.net M365_fqdn_wildcard.virtualearth.net *.virtualearth.net M365_fqdn_wildcard.wns.windows.com *.wns.windows.com M365_fqdn_wildcard.yammer.com *.yammer.com M365_fqdn_wildcard.yammerusercontent.com *.yammerusercontent.com M365_fqdn_wildcardcdn.onenote.net *cdn.onenote.net M365_fqdn_account.activedirectory.windowsazure.com account.activedirectory.windowsazure.com M365_fqdn_account.live.com account.live.com M365_fqdn_accounts.accesscontrol.windows.net accounts.accesscontrol.windows.net M365_fqdn_activation.sls.microsoft.com activation.sls.microsoft.com M365_fqdn_activity.windows.com activity.windows.com M365_fqdn_adl.windows.com adl.windows.com M365_fqdn_admin.microsoft.com admin.microsoft.com M365_fqdn_admin.onedrive.com admin.onedrive.com M365_fqdn_adminwebservice.microsoftonline.com adminwebservice.microsoftonline.com M365_fqdn_ajax.aspnetcdn.com ajax.aspnetcdn.com M365_fqdn_aka.ms aka.ms M365_fqdn_amp.azure.net amp.azure.net M365_fqdn_api.passwordreset.microsoftonline.com api.passwordreset.microsoftonline.com M365_fqdn_apis.live.net apis.live.net M365_fqdn_apps.identrust.com apps.identrust.com M365_fqdn_appsforoffice.microsoft.com appsforoffice.microsoft.com M365_fqdn_assets.onestore.ms assets.onestore.ms M365_fqdn_auth.gfx.ms auth.gfx.ms M365_fqdn_autologon.microsoftazuread-sso.com autologon.microsoftazuread-sso.com M365_fqdn_becws.microsoftonline.com becws.microsoftonline.com M365_fqdn_c.bing.com c.bing.com M365_fqdn_c.bing.net c.bing.net M365_fqdn_c.live.com c.live.com M365_fqdn_c1.microsoft.com c1.microsoft.com M365_fqdn_cacerts.digicert.com cacerts.digicert.com M365_fqdn_ccs.login.microsoftonline.com ccs.login.microsoftonline.com M365_fqdn_cdn.odc.officeapps.live.com cdn.odc.officeapps.live.com M365_fqdn_cdn.uci.officeapps.live.com cdn.uci.officeapps.live.com M365_fqdn_cert.int-x3.letsencrypt.org cert.int-x3.letsencrypt.org M365_fqdn_clientconfig.microsoftonline-p.net clientconfig.microsoftonline-p.net M365_fqdn_companymanager.microsoftonline.com companymanager.microsoftonline.com M365_fqdn_compass-ssl.microsoft.com compass-ssl.microsoft.com M365_fqdn_compliance.microsoft.com compliance.microsoft.com M365_fqdn_crl.globalsign.com crl.globalsign.com M365_fqdn_crl.globalsign.net crl.globalsign.net M365_fqdn_crl.identrust.com crl.identrust.com M365_fqdn_crl.microsoft.com crl.microsoft.com M365_fqdn_crl3.digicert.com crl3.digicert.com M365_fqdn_crl4.digicert.com crl4.digicert.com M365_fqdn_d.docs.live.net d.docs.live.net M365_fqdn_dc.services.visualstudio.com dc.services.visualstudio.com M365_fqdn_defender.microsoft.com defender.microsoft.com M365_fqdn_device.login.microsoftonline.com device.login.microsoftonline.com M365_fqdn_dgps.support.microsoft.com dgps.support.microsoft.com M365_fqdn_docs.live.net docs.live.net M365_fqdn_docs.microsoft.com docs.microsoft.com M365_fqdn_ecn.dev.virtualearth.net ecn.dev.virtualearth.net M365_fqdn_enterpriseregistration.windows.net enterpriseregistration.windows.net M365_fqdn_eus-www.sway-cdn.com eus-www.sway-cdn.com M365_fqdn_eus-www.sway-extensions.com eus-www.sway-extensions.com M365_fqdn_firstpartyapps.oaspapps.com firstpartyapps.oaspapps.com M365_fqdn_g.live.com g.live.com M365_fqdn_go.microsoft.com go.microsoft.com M365_fqdn_graph.microsoft.com graph.microsoft.com M365_fqdn_graph.windows.net graph.windows.net M365_fqdn_informationprotection.hosting.portal.azure.net informationprotection.hosting.portal.azure.net M365_fqdn_isrg.trustid.ocsp.identrust.com isrg.trustid.ocsp.identrust.com M365_fqdn_login-us.microsoftonline.com login-us.microsoftonline.com M365_fqdn_login.live.com login.live.com M365_fqdn_login.microsoft.com login.microsoft.com M365_fqdn_login.microsoftonline-p.com login.microsoftonline-p.com M365_fqdn_login.microsoftonline.com login.microsoftonline.com M365_fqdn_login.windows-ppe.net login.windows-ppe.net M365_fqdn_login.windows.net login.windows.net M365_fqdn_logincert.microsoftonline.com logincert.microsoftonline.com M365_fqdn_loginex.microsoftonline.com loginex.microsoftonline.com M365_fqdn_mem.gfx.ms mem.gfx.ms M365_fqdn_mlccdn.blob.core.windows.net mlccdn.blob.core.windows.net M365_fqdn_mlccdnprod.azureedge.net mlccdnprod.azureedge.net M365_fqdn_mscrl.microsoft.com mscrl.microsoft.com M365_fqdn_msdn.microsoft.com msdn.microsoft.com M365_fqdn_nexus.microsoftonline-p.com nexus.microsoftonline-p.com M365_fqdn_nps.onyx.azure.net nps.onyx.azure.net M365_fqdn_o15.officeredir.microsoft.com o15.officeredir.microsoft.com M365_fqdn_ocos-office365-s2s.msedge.net ocos-office365-s2s.msedge.net M365_fqdn_ocsp.digicert.com ocsp.digicert.com M365_fqdn_ocsp.globalsign.com ocsp.globalsign.com M365_fqdn_ocsp.msocsp.com ocsp.msocsp.com M365_fqdn_ocsp2.globalsign.com ocsp2.globalsign.com M365_fqdn_ocspx.digicert.com ocspx.digicert.com M365_fqdn_office.live.com office.live.com M365_fqdn_office15client.microsoft.com office15client.microsoft.com M365_fqdn_officeapps.live.com officeapps.live.com M365_fqdn_officecdn.microsoft.com officecdn.microsoft.com M365_fqdn_officecdn.microsoft.com.edgesuite.net officecdn.microsoft.com.edgesuite.net M365_fqdn_officeclient.microsoft.com officeclient.microsoft.com M365_fqdn_officepreviewredir.microsoft.com officepreviewredir.microsoft.com M365_fqdn_officeredir.microsoft.com officeredir.microsoft.com M365_fqdn_officespeech.platform.bing.com officespeech.platform.bing.com M365_fqdn_oneclient.sfx.ms oneclient.sfx.ms M365_fqdn_otelrules.azureedge.net otelrules.azureedge.net M365_fqdn_outlook.office.com outlook.office.com M365_fqdn_outlook.office365.com outlook.office365.com M365_fqdn_partnerservices.getmicrosoftkey.com partnerservices.getmicrosoftkey.com M365_fqdn_passwordreset.microsoftonline.com passwordreset.microsoftonline.com M365_fqdn_platform.linkedin.com platform.linkedin.com M365_fqdn_policykeyservice.dc.ad.msft.net policykeyservice.dc.ad.msft.net M365_fqdn_prod.firstpartyapps.oaspapps.com.akadns.net prod.firstpartyapps.oaspapps.com.akadns.net M365_fqdn_prod.msocdn.com prod.msocdn.com M365_fqdn_protection.office.com protection.office.com M365_fqdn_provisioningapi.microsoftonline.com provisioningapi.microsoftonline.com M365_fqdn_r.office.microsoft.com r.office.microsoft.com M365_fqdn_secure.globalsign.com secure.globalsign.com M365_fqdn_security.microsoft.com security.microsoft.com M365_fqdn_shellprod.msocdn.com shellprod.msocdn.com M365_fqdn_signup.live.com signup.live.com M365_fqdn_smtp.office365.com smtp.office365.com M365_fqdn_spoprod-a.akamaihd.net spoprod-a.akamaihd.net M365_fqdn_ssw.live.com ssw.live.com M365_fqdn_staffhub.ms staffhub.ms M365_fqdn_storage.live.com storage.live.com M365_fqdn_support.microsoft.com support.microsoft.com M365_fqdn_sway.com sway.com M365_fqdn_teams.microsoft.com teams.microsoft.com M365_fqdn_technet.microsoft.com technet.microsoft.com M365_fqdn_telemetryservice.firstpartyapps.oaspapps.com telemetryservice.firstpartyapps.oaspapps.com M365_fqdn_tse1.mm.bing.net tse1.mm.bing.net M365_fqdn_wus-firstpartyapps.oaspapps.com wus-firstpartyapps.oaspapps.com M365_fqdn_wus-www.sway-cdn.com wus-www.sway-cdn.com M365_fqdn_wus-www.sway-extensions.com wus-www.sway-extensions.com M365_fqdn_www.acompli.com www.acompli.com M365_fqdn_www.bing.com www.bing.com M365_fqdn_www.digicert.com www.digicert.com M365_fqdn_www.microsoft.com www.microsoft.com M365_fqdn_www.microsoft365.com www.microsoft365.com M365_fqdn_www.onedrive.com www.onedrive.com M365_fqdn_www.outlook.com www.outlook.com M365_fqdn_www.sway.com www.sway.com grp_M365_FQDN All FQDNs from Microsoft M365_fqdn_wildcard.aadrm.com M365_fqdn_wildcard.acompli.net M365_fqdn_wildcard.activity.windows.com M365_fqdn_wildcard.appex-rf.msn.com M365_fqdn_wildcard.appex.bing.com M365_fqdn_wildcard.aria.microsoft.com M365_fqdn_wildcard.assets-yammer.com M365_fqdn_wildcard.auth.microsoft.com M365_fqdn_wildcard.azure-apim.net M365_fqdn_wildcard.azureedge.net M365_fqdn_wildcard.azurerms.com M365_fqdn_wildcard.blob.core.windows.net M365_fqdn_wildcard.compliance.microsoft.com M365_fqdn_wildcard.cortana.ai M365_fqdn_wildcard.entrust.net M365_fqdn_wildcard.events.data.microsoft.com M365_fqdn_wildcard.flow.microsoft.com M365_fqdn_wildcard.geotrust.com M365_fqdn_wildcard.hip.live.com M365_fqdn_wildcard.informationprotection.azure.com M365_fqdn_wildcard.keydelivery.mediaservices.windows.net M365_fqdn_wildcard.lync.com M365_fqdn_wildcard.mail.protection.outlook.com M365_fqdn_wildcard.media.azure.net M365_fqdn_wildcard.microsoft.com M365_fqdn_wildcard.microsoftonline-p.com M365_fqdn_wildcard.microsoftonline.com M365_fqdn_wildcard.microsoftstream.com M365_fqdn_wildcard.microsoftusercontent.com M365_fqdn_wildcard.msauth.net M365_fqdn_wildcard.msauthimages.net M365_fqdn_wildcard.msecnd.net M365_fqdn_wildcard.msftauth.net M365_fqdn_wildcard.msftauthimages.net M365_fqdn_wildcard.msftidentity.com M365_fqdn_wildcard.msidentity.com M365_fqdn_wildcard.msocdn.com M365_fqdn_wildcard.o365weve.com M365_fqdn_wildcard.office.com M365_fqdn_wildcard.office.net M365_fqdn_wildcard.office365.com M365_fqdn_wildcard.officeapps.live.com M365_fqdn_wildcard.omniroot.com M365_fqdn_wildcard.onenote.com M365_fqdn_wildcard.online.office.com M365_fqdn_wildcard.onmicrosoft.com M365_fqdn_wildcard.outlook.com M365_fqdn_wildcard.outlookmobile.com M365_fqdn_wildcard.phonefactor.net M365_fqdn_wildcard.portal.cloudappsecurity.com M365_fqdn_wildcard.powerapps.com M365_fqdn_wildcard.powerautomate.com M365_fqdn_wildcard.protection.office.com M365_fqdn_wildcard.protection.outlook.com M365_fqdn_wildcard.public-trust.com M365_fqdn_wildcard.search.production.apac.trafficmanager.net M365_fqdn_wildcard.search.production.emea.trafficmanager.net M365_fqdn_wildcard.search.production.us.trafficmanager.net M365_fqdn_wildcard.secure.skypeassets.com M365_fqdn_wildcard.security.microsoft.com M365_fqdn_wildcard.sharepoint.com M365_fqdn_wildcard.sharepointonline.com M365_fqdn_wildcard.skype.com M365_fqdn_wildcard.streaming.mediaservices.windows.net M365_fqdn_wildcard.svc.ms M365_fqdn_wildcard.symcb.com M365_fqdn_wildcard.symcd.com M365_fqdn_wildcard.teams.microsoft.com M365_fqdn_wildcard.users.storage.live.com M365_fqdn_wildcard.verisign.com M365_fqdn_wildcard.verisign.net M365_fqdn_wildcard.virtualearth.net M365_fqdn_wildcard.wns.windows.com M365_fqdn_wildcard.yammer.com M365_fqdn_wildcard.yammerusercontent.com M365_fqdn_wildcardcdn.onenote.net M365_fqdn_account.activedirectory.windowsazure.com M365_fqdn_account.live.com M365_fqdn_accounts.accesscontrol.windows.net M365_fqdn_activation.sls.microsoft.com M365_fqdn_activity.windows.com M365_fqdn_adl.windows.com M365_fqdn_admin.microsoft.com M365_fqdn_admin.onedrive.com M365_fqdn_adminwebservice.microsoftonline.com M365_fqdn_ajax.aspnetcdn.com M365_fqdn_aka.ms M365_fqdn_amp.azure.net M365_fqdn_api.passwordreset.microsoftonline.com M365_fqdn_apis.live.net M365_fqdn_apps.identrust.com M365_fqdn_appsforoffice.microsoft.com M365_fqdn_assets.onestore.ms M365_fqdn_auth.gfx.ms M365_fqdn_autologon.microsoftazuread-sso.com M365_fqdn_becws.microsoftonline.com M365_fqdn_c.bing.com M365_fqdn_c.bing.net M365_fqdn_c.live.com M365_fqdn_c1.microsoft.com M365_fqdn_cacerts.digicert.com M365_fqdn_ccs.login.microsoftonline.com M365_fqdn_cdn.odc.officeapps.live.com M365_fqdn_cdn.uci.officeapps.live.com M365_fqdn_cert.int-x3.letsencrypt.org M365_fqdn_clientconfig.microsoftonline-p.net M365_fqdn_companymanager.microsoftonline.com M365_fqdn_compass-ssl.microsoft.com M365_fqdn_compliance.microsoft.com M365_fqdn_crl.globalsign.com M365_fqdn_crl.globalsign.net M365_fqdn_crl.identrust.com M365_fqdn_crl.microsoft.com M365_fqdn_crl3.digicert.com M365_fqdn_crl4.digicert.com M365_fqdn_d.docs.live.net M365_fqdn_dc.services.visualstudio.com M365_fqdn_defender.microsoft.com M365_fqdn_device.login.microsoftonline.com M365_fqdn_dgps.support.microsoft.com M365_fqdn_docs.live.net M365_fqdn_docs.microsoft.com M365_fqdn_ecn.dev.virtualearth.net M365_fqdn_enterpriseregistration.windows.net M365_fqdn_eus-www.sway-cdn.com M365_fqdn_eus-www.sway-extensions.com M365_fqdn_firstpartyapps.oaspapps.com M365_fqdn_g.live.com M365_fqdn_go.microsoft.com M365_fqdn_graph.microsoft.com M365_fqdn_graph.windows.net M365_fqdn_informationprotection.hosting.portal.azure.net M365_fqdn_isrg.trustid.ocsp.identrust.com M365_fqdn_login-us.microsoftonline.com M365_fqdn_login.live.com M365_fqdn_login.microsoft.com M365_fqdn_login.microsoftonline-p.com M365_fqdn_login.microsoftonline.com M365_fqdn_login.windows-ppe.net M365_fqdn_login.windows.net M365_fqdn_logincert.microsoftonline.com M365_fqdn_loginex.microsoftonline.com M365_fqdn_mem.gfx.ms M365_fqdn_mlccdn.blob.core.windows.net M365_fqdn_mlccdnprod.azureedge.net M365_fqdn_mscrl.microsoft.com M365_fqdn_msdn.microsoft.com M365_fqdn_nexus.microsoftonline-p.com M365_fqdn_nps.onyx.azure.net M365_fqdn_o15.officeredir.microsoft.com M365_fqdn_ocos-office365-s2s.msedge.net M365_fqdn_ocsp.digicert.com M365_fqdn_ocsp.globalsign.com M365_fqdn_ocsp.msocsp.com M365_fqdn_ocsp2.globalsign.com M365_fqdn_ocspx.digicert.com M365_fqdn_office.live.com M365_fqdn_office15client.microsoft.com M365_fqdn_officeapps.live.com M365_fqdn_officecdn.microsoft.com M365_fqdn_officecdn.microsoft.com.edgesuite.net M365_fqdn_officeclient.microsoft.com M365_fqdn_officepreviewredir.microsoft.com M365_fqdn_officeredir.microsoft.com M365_fqdn_officespeech.platform.bing.com M365_fqdn_oneclient.sfx.ms M365_fqdn_otelrules.azureedge.net M365_fqdn_outlook.office.com M365_fqdn_outlook.office365.com M365_fqdn_partnerservices.getmicrosoftkey.com M365_fqdn_passwordreset.microsoftonline.com M365_fqdn_platform.linkedin.com M365_fqdn_policykeyservice.dc.ad.msft.net M365_fqdn_prod.firstpartyapps.oaspapps.com.akadns.net M365_fqdn_prod.msocdn.com M365_fqdn_protection.office.com M365_fqdn_provisioningapi.microsoftonline.com M365_fqdn_r.office.microsoft.com M365_fqdn_secure.globalsign.com M365_fqdn_security.microsoft.com M365_fqdn_shellprod.msocdn.com M365_fqdn_signup.live.com M365_fqdn_smtp.office365.com M365_fqdn_spoprod-a.akamaihd.net M365_fqdn_ssw.live.com M365_fqdn_staffhub.ms M365_fqdn_storage.live.com M365_fqdn_support.microsoft.com M365_fqdn_sway.com M365_fqdn_teams.microsoft.com M365_fqdn_technet.microsoft.com M365_fqdn_telemetryservice.firstpartyapps.oaspapps.com M365_fqdn_tse1.mm.bing.net M365_fqdn_wus-firstpartyapps.oaspapps.com M365_fqdn_wus-www.sway-cdn.com M365_fqdn_wus-www.sway-extensions.com M365_fqdn_www.acompli.com M365_fqdn_www.bing.com M365_fqdn_www.digicert.com M365_fqdn_www.microsoft.com M365_fqdn_www.microsoft365.com M365_fqdn_www.onedrive.com M365_fqdn_www.outlook.com M365_fqdn_www.sway.com It would be great if someone could help me with this problem. Thank you very much.

dtconnect · Answer

I've attempted to import your XML via the API and noticed the following:

<FQDNHost transactionid="">
  <Name>M365_fqdn_wildcard.microsoft.com</Name>
  <FQDN>*.microsoft.com</FQDN>
</FQDNHost>

There's already a default entry for *.microsoft.com in the FQDN definitions (*.microsoft.com). Unfortunately, you can't add another FQDN Host with an already existing FQDN (I know, it's frustrating).

This issue might be the same for other entries as well, such as login.microsoft.com, login.microsoftonline.com, etc. I've tested this with a v19.5 API.

This will lead to an error:

<Status code="504">Operation failed. Deleting entity referred by another entity.</Status>

Consequently, the FQDN Host group import will fail, displaying a rather unhelpful error:

<Status code="501">Configuration parameters validation failed.</Status>
<InvalidParams> 
  <Params>/FQDNHostGroup/Name</Params>
</InvalidParams>

The actual issue is the missing FQDNHost M365_fqdn_wildcard.microsoft.com, although the error message might suggest a problem with the HostgroupName (which is actually fine).

Also, remember: FQDN Host entries must not exceed 60 characters in length. You're currently within limits, but it might be wise to implement some sort of length check.

I assume the importer does some sort of rollback because some of your objects get imported if you do it directly via API (with <set operation="add">).

API-Import not working with Error "Action with NOFAIL Failed."

Top Replies