Skip to main content

Some countries doesn't exist when using de API

  • November 15, 2023
  • 4 replies
  • 405 views
M

Hi all,

We are importing with the API account using the country field.
An error occured when we tried to inject the “RE” code “La réunion” or “Reunion island”.

We found the country code comes on the Monday API documentation from the following URL : Country

This URL redirect to the following JSON file : http://country.io/names.json

the “RE” code exists in this file but the API refuses it.
When we try to type this country on a board, the country doesn’t exists.

Is it a bug because of the accent “é” ?
Is this country recently hidden ?
Is the JSON is outdated ?

If other countries are in the same case, can you give us a list of these ?

Thank you for your help

4 replies

A
  • anon29275264
  • Participating Frequently
  • November 22, 2023

This should be posted in the “monday Apps & Developers” category for API questions, you are much more likely to get responses to API questions in the correct category.

Platform Discussions are about using the monday.com platform, and the monday apps & integrations subcategory is specifically about using apps and integrations.

    Matias.Monday
    Forum|alt.badge.img
    • Matias.Monday
    • monday.com Team Member
    • November 23, 2023

    Hello there @Marc_Furberg,

    Would you be able to send this to appsupport@monday.com with the exact query you are using and the response you are getting?

    Looking forward to hearing from you via email!

    Cheers,
    Matias

      M
      • Marc_Furberg
      • Author
      • Participating Frequently
      • November 23, 2023

      mutation {
      create_item(board_id: 123456789, item_name: “marc”,
      column_values:“{"country":{"countryCode":"RE","countryName":"Reunion"}}”
      )
      {
      id
      }
      }

      or

      mutation {
      create_item(board_id: 123456789, item_name: “marc”,
      column_values:“{"country":{"countryCode":"RE"}}”
      )
      {
      id
      }
      }

      The error returned is
      {
      error_code=ColumnValueException,
      status_code=200,
      error_message=invalid value, please check our API documentation for the correct data structure for this column. Guide to Changing Column Values (Guide to Changing Column Values) ,
      error_data={column_value={“countryCode”=>“RE”},
      column_type=CountryColumn}
      }

      I jsut tried it and it seems it has been solved recently ! Can you confirm ?

      Are there others countries like “RE” ?

      Matias.Monday
      Forum|alt.badge.img
      • Matias.Monday
      • monday.com Team Member
      • November 26, 2023

      Hello again @Marc_Furberg,

      I am glad this is resolved!

      For me to check with the team, I need you to please send this over to appsupport@monday.com.

      From there we could investigate a bit more about this if you need.

      Cheers,
      Matias

        Terms & ConditionsCookie settingsAccessibility statement