Microsoft Fabric: JSON Deserialization to Ingest Census Data in Microsoft Fabric!

[@KurtJ-r8w]

Please detail more how you added the API and parameterized it

[@Tales-from-the-Field]

Hi @KurtJ-r8w per Bradley, "Hi @KurtJ-r8w You have to sign up for an API Key at the www.census.gov/ website. They will email you an API Key you can use. Then I'm making a call using pyspark. I parameterize the API key but it's just by setting a variable saying APIKey='insert the api key from the email' this is what I'm covering from the 3 minute mark to the 4:17 minute mark. After that I'm using beautiful soup to load the irregularly formed JSON to parse the data as a list file and assign the data frame schema to it. I hope this helps! "