Get FX Rates in Graphql

This query returns currency rates for a specific date and specific currency . 

 

 

 

 GraphQL Query 

 query GetCurrencyHistoryList {

 currency_history(

 pagination: {

 limit: 20

 offset: 0

 }

 filters: {

 date: {

 exact: "2023-12-01"

 }

 pricing_policy: {

 user_code:{

 exact: "com.finmars.standard-pricing:standard"

 }

 }

 currency: {

 user_code: {

 exact: "CHF"

 }

 }

 }

 ) {

 id

 date

 fx_rate

 currency {

 id

 user_code

 name

 }

 }

} 

 

 Python Example 

 import requests

url = "https://<domain_name>/<realm_code>/<space_code>/graphql/"

headers = {

 "Authorization": "Bearer <access_token>",

 "Content-Type": "application/json"

}

payload = {

 "query": """

 query GetCurrencyHistoryList {

 currency_history(

 pagination: {

 limit: 20

 offset: 0

 }

 filters: {

 date: {

 exact: "2023-12-01"

 }

 pricing_policy: {

 user_code:{

 exact: "com.finmars.standard-pricing:standard"

 }

 }

 currency: {

 user_code: {

 exact: "CHF"

 }

 }

 }

 ) {

 id

 date

 fx_rate

 currency {

 id

 user_code

 name

 }

 }

 }

 """

}

response = requests.post(url, json=payload, headers=headers)

print(response.json()) 

 

 Filter Highlights 

 Exact Match 

 date: {

 exact: "2023-12-01"

} 

 Matches one exact value Type must match schema Dates are strings in ISO format 

 

 Nested Filters 

 currency: {

 user_code: {

 exact: "CHF"

 }

} 

 Filters on related objects Works through foreign keys Depth depends on schema rules 

 

 Common Filter Types 

 Typical filters you may see: 

 exact in contains gte , lte isnull 

 Available filters depend on the field type. 

 

 Important Notes 

 Filters are optional Multiple filters are combined with AND Wrong field names cause schema errors Always check the schema panel 

 This pattern applies to all list queries in Finmars GraphQL.