# 2018 ACS1 Metadata

**URL:** <https://forum.ipums.org/t/2018-acs1-metadata/3643>\
**Category:** IPUMS API\
**Created:** [July 15, 2020, 9:19pm UTC](https://forum.ipums.org/t/2018-acs1-metadata/3643 "2020-07-15T21:19:28Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Brian\_Cultice](https://avatars.discourse-cdn.com/v4/letter/b/91b2a8/32.png) [@Brian\_Cultice](https://forum.ipums.org/u/Brian_Cultice)\
**Post date:** [July 15, 2020, 9:19pm UTC](https://forum.ipums.org/t/2018-acs1-metadata/3643/1 "2020-07-15T21:19:28Z")

</div>

Hello all,

I am having trouble successfully requesting table-specific metadata for the 2018\_ACS 1-Year dataset.

Apologies for the extremely general inquiry, but I cannot identify the issue. The table(s) I am attempting to pull metadata from show up in the single dataset metadata. See below for a portion of my function.

I appreciate any assistance you can provide.

```auto
dataset <- "2018_ACS1"
tabl <- "AIT3"

NHGIS_datasetdl <- function(auth_key, dataset, tabl, ) {
  file_downloads <- "./Downloads"
  
  ### Step 1: Download the metadata for each table
  ipums_url <- paste0("https://api.ipums.org/metadata/nhgis/datasets/", dataset, "/data_tables/", tabl, "?version=v1")
  ipums_md <- GET(ipums_url, add_headers(Authorization = auth_key))
  ipums_md <- content(ipums_md, "parsed", simplifyDataFrame = TRUE)

```

---

<div class="post-metadata">

**Author:** ![fran](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.ipums.org/fran/32/363_2.png) [@fran](https://forum.ipums.org/u/fran)\
**Post date:** [July 15, 2020, 9:27pm UTC](https://forum.ipums.org/t/2018-acs1-metadata/3643/2 "2020-07-15T21:27:32Z")

</div>

Hi Brian,

Let’s see if we can help you troubleshoot this! What HTTP Status Code and response payload are getting returned from the API?

Thanks,  
Fran

---

<div class="post-metadata">

**Author:** ![fran](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.ipums.org/fran/32/363_2.png) [@fran](https://forum.ipums.org/u/fran)\
**Post date:** [July 15, 2020, 9:39pm UTC](https://forum.ipums.org/t/2018-acs1-metadata/3643/3 "2020-07-15T21:39:29Z")

</div>

When I try your URL ([https://api.ipums.org/metadata/nhgis/datasets/2018\_ACS1/data\_tables/AIT3?version=v1](https://api.ipums.org/metadata/nhgis/datasets/2018_ACS1/data_tables/AIT3?version=v1)), I get the following response from the API:

```auto
{
    "type": "RecordNotFound",
    "status": {
        "code": 404,
        "name": "Not Found"
    },
    "detail": "Couldn't find DataTable."
}

```

That clue helped me realize the underlying issue - you want to use the datatable **name** from the dataset metadata for the datatable, not the NHGIS code. So for the table with NHGIS code AIT3, you’d want to use B01001 there instead: [https://api.ipums.org/metadata/nhgis/datasets/2018\_ACS1/data\_tables/B01001?version=v1](https://api.ipums.org/metadata/nhgis/datasets/2018_ACS1/data_tables/B01001?version=v1)

Hope that helps!

---

<div class="post-metadata">

**Author:** ![Brian\_Cultice](https://avatars.discourse-cdn.com/v4/letter/b/91b2a8/32.png) [@Brian\_Cultice](https://forum.ipums.org/u/Brian_Cultice)\
**Post date:** [July 15, 2020, 9:56pm UTC](https://forum.ipums.org/t/2018-acs1-metadata/3643/4 "2020-07-15T21:56:54Z")

</div>

Hey thank you for the quick response!

1. 404 Not Found
2. Not sure? Is there something specific you’d want? Apologize for my ignorance

---

<div class="post-metadata">

**Author:** ![Brian\_Cultice](https://avatars.discourse-cdn.com/v4/letter/b/91b2a8/32.png) [@Brian\_Cultice](https://forum.ipums.org/u/Brian_Cultice)\
**Post date:** [July 15, 2020, 9:59pm UTC](https://forum.ipums.org/t/2018-acs1-metadata/3643/5 "2020-07-15T21:59:45Z")

</div>

Thank you!! Btw I think the example workflows use the NHGIS table codes, but that might be specific to the dataset referenced.

---

<div class="post-metadata">

**Author:** ![fran](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.ipums.org/fran/32/363_2.png) [@fran](https://forum.ipums.org/u/fran)\
**Post date:** [July 15, 2020, 10:06pm UTC](https://forum.ipums.org/t/2018-acs1-metadata/3643/6 "2020-07-15T22:06:46Z")

</div>

Happy to help.

I glanced through the developer docs for this part of the workflow ([IPUMS NHGIS Dataset Metadata | IPUMS Developer Portal](https://developer.ipums.org/docs/workflows/explore_metadata/nhgis/datasets/)) and it looks like we are using the data table names in the examples, but if you do come across an example where we’ve mistakenly used the code instead, let us know and we’ll get that cleaned up.

Thanks!