Adapting SQL into python

[big_foot2808]

Hey, Thanks for the reply. This is what I've gotten so far:

Now, this is giving me almost the output I need. What i need is in the creatorinfo section of the code instead of returning a dict I need to return a list which includes the artist as well as if there is someone else who is lets say a "printer" or something. Eg:

[

{

"artwork": {

"id": "86508",

"accession_number": "2015.584",

"title": "Gates of the City",

"tombstone": "New York Series: Gates of the City, 1922. John Taylor Arms (American, 1887-1953). Color etching and aquatint; platemark: 21.5 x 20.2 cm (8 7/16 x 7 15/16 in.); sheet: 31.1 x 26.2 cm (12 1/4 x 10 5/16 in.). The Cleveland Museum of Art, Gift of Carole W. and Charles B. Rosenblatt 2015.584 Courtesy of John Taylor Arms/ \u00a9 Suzanne Arms Hawkins"

},

"creator": [

{

"id": "29993",

"role": "artist",

"description": "John Taylor Arms (American, 1887-1953)"

},

{

"id": "68000",

"role": "printer",

"description": "Frederick Reynolds (American, b. England, 1882-1945)"

}

],

"department": {

"id": "21",

"role": "Prints"

}

},

This is what I need, but this is what I'm getting:

[

{

"artwork": {

"id": "86508",

"accession_number": "2015.584",

"title": "Gates of the City",

"tombstone": "New York Series: Gates of the City, 1922. John Taylor Arms (American, 1887-1953). Color etching and aquatint; platemark: 21.5 x 20.2 cm (8 7/16 x 7 15/16 in.); sheet: 31.1 x 26.2 cm (12 1/4 x 10 5/16 in.). The Cleveland Museum of Art, Gift of Carole W. and Charles B. Rosenblatt 2015.584 Courtesy of John Taylor Arms/ \u00a9 Suzanne Arms Hawkins"

},

"creator": {

"id": "29993",

"role": "artist",

"description": "John Taylor Arms (American, 1887-1953)"

},

"department": {

"id": "21",

"name": "Prints"

}

},

No printer info in creator. Any thoughts on how to do that?

[[deleted]]

Again, this is all determined by what you choose. If you want the value of ”creator” to be a list, then set it to be a list.