This message means you have a problem, usually with a website address in your data.
This error is often caused by the following problems:
What is a URI? Short for “Uniform Resource Identifier” it is a sequence of characters that distinguishes one resource from another. A URL — short for “Uniform Resource Locator” — is a specific type of URI.
When the 360Giving Data Standard requires data to be provided in the format of a URI, this will mean you will very likely be providing a URL — or website address.
Dates should be in the formats defined by the 360Giving Data Standard.
All Last Modified fields should be in datetime format and all other dates, such as Award Dates and Planned Dates, should be in the YYYY-MM-DD format. However, Award and Planned Dates can also be provided in datetime format.
Dates should be in the form YYYY-MM-DD where:
Example: 2022-01-01
Common date errors include
All Last Modified fields should be in datetime format, which is a very specific form of a date and time that is specified by the 360Giving Data Standard.
A datetime should be in the form of YYYY-MM-DDThh:mm:ss±hh:mm where:
Example: 2022-01-01T12:00:00Z is 12 noon on the 1st January 2022 in UTC time
You can find further guidance here about date and datetime fields in the 360Giving data, as well as formatting tips when publishing using spreadsheets.
There are 10 core fields that are required in the 360Giving Data Standard.
If any of the following fields are missing, the data is invalid against the schema.
This error message might be triggered because the data is missing or because of a spelling or formatting mistake in the field title. See the full list of field titles for the correct spelling and formatting for the rest of the 360Giving Data Standard.
Field | JSON value | Notes | Documentation |
---|---|---|---|
Amount Awarded | amountAwarded | Every grant needs to specify the amount of money awarded | |
Award Date | awardDate | Every grant needs to specify the date that it was awarded. | Dates |
Currency | currency | Every grant needs to specify the currency that the grant was made in. | |
Description | description | Every grant needs a human readable description. | |
Identifier | id | Every grant needs a unique identifier so we can tell them apart | Grant Identifiers |
Funding Org | fundingOrganization | Every grant needs a funding organisation that makes the award. | |
Funding Org:Identifier | fundingOrganization/id | Every organisation needs a unique identifier so we can tell them apart.. | Organisation Identifiers |
Funding Org:Name | fundingOrganization/name | Every organisation needs a human readable name. | |
Recipient Org | recipientOrganization | Every grant needs a to specify an organisation to which the grant is awarded. | |
Recipient Org:Identifier | recipientOrganization/id | Every organisation a unique identifier so we can tell them apart. | Organisation Identifiers |
Recipient Org:Name | recipientOrganization/name | Every organisation needs a human readable name. | |
Title | title | Every grant needs a human readable title. |
In the 360Giving Data Standard, there are three fields that require publishers to use values from a predefined list. When we validate people's data, we check the values of those fields against those lists.
This error tells us that we have found something not on the list for one or more of these fields.
Field | JSON value | Description |
---|---|---|
Currency | currency | The currency used in amounts. Use the three-letter currency code from ISO 4217 eg: Use GBP for Pounds Sterling. |
Beneficiary, Recipient Org or Funding Org Location:Country Code | countryCode | The 2-character ISO Country Code of the location of this activity. Taken from ISO-3166-1-alpha-2 |
From An Open Call? | fromOpenCall | Was this grant made as the result of an open call for applications? Values must be ‘Yes‘ or ‘No‘ |
The currency and country code lists are referenced in the 360Giving JSON Schemas and the field descriptions link to the code lists on third-party websites.
x
is not a stringData in the 360Giving Data Standard is expected to be provided in a certain format.
Strings are generally text, but can contain other characters such as numbers. Sometimes spreadsheet software can alter the format of data so that it is no longer a string.
To fix these kinds of errors, check the field to make sure you are supplying the data in the form of a string.
If using JSON format: check that the value is not null, and has quotes at the start and end. Escape any quotes in the value with \
x
is not a numberData in the 360 Giving Data Standard is expected to be provided in a certain format.
To fix these kinds of errors, check the field to make sure you are supplying the data in the form of a number. Check that the value is not null, and doesn’t contain any characters other than 0-9 and dot (.). Number values should not be in quotes.
x
is less than the minimum of 0A duration value cannot be a minus number. This error can be caused because the duration has been automatically calculated from a Start Date and End Date but these have been accidentally reversed or there is a typo in a date.
To fix these kinds of errors, make sure all Start Dates are before End Dates so the duration can be calculated correctly.
For further information see our guide on using the data quality tool and technical reference for the 360Giving Data Standard.