I would like to filter on a workbook and get all field names, regardless of field type (if the field is a calculation, get the formula too). The following GraphQL query doesn't work, but it is my best shot.
query bestattempt {
fields {
downstreamWorkbooks(filter: {name: "Random WB name"}) {
name
}
name
... on CalculatedField {
formula
}
}
}
4 answers
Hi Caleb, try this:
query workbookFields {
workbooks(filter: {name: "testjuly19"}) {
name
sheets {
name
sheetFieldInstances {
name
... on CalculatedField {
formula
}
}
}
}
}
Use "datasourceFields" if you also want to include fields that were used in calculations but not actually on the worksheets.
-Keshia
