Network.Google.Resource.Sheets.Spreadsheets.Values.Get

Returns a range of values from a spreadsheet. The caller must specify the spreadsheet ID and a range.

See: Google Sheets API Reference for sheets.spreadsheets.values.get.

REST Resource

type SpreadsheetsValuesGetResource = "v4" :> ("spreadsheets" :> (Capture "spreadsheetId" Text :> ("values" :> (Capture "range" Text :> (QueryParam "$.xgafv" Xgafv :> (QueryParam "valueRenderOption" Text :> (QueryParam "upload_protocol" Text :> (QueryParam "pp" Bool :> (QueryParam "access_token" Text :> (QueryParam "uploadType" Text :> (QueryParam "bearer_token" Text :> (QueryParam "dateTimeRenderOption" Text :> (QueryParam "majorDimension" Text :> (QueryParam "callback" Text :> (QueryParam "alt" AltJSON :> Get '[JSON] ValueRange)))))))))))))))

A resource alias for sheets.spreadsheets.values.get method which the SpreadsheetsValuesGet request conforms to.

Creating a Request

spreadsheetsValuesGet

Arguments

:: Text

svgSpreadsheetId

-> Text

svgRange

-> SpreadsheetsValuesGet

Creates a value of SpreadsheetsValuesGet with the minimum fields required to make a request.

Use one of the following lenses to modify other fields as desired:

• svgXgafv
• svgValueRenderOption
• svgUploadProtocol
• svgPp
• svgAccessToken
• svgSpreadsheetId
• svgUploadType
• svgBearerToken
• svgRange
• svgDateTimeRenderOption
• svgMajorDimension
• svgCallback

data SpreadsheetsValuesGet

Returns a range of values from a spreadsheet. The caller must specify the spreadsheet ID and a range.

See: spreadsheetsValuesGet smart constructor.

Instances

Eq SpreadsheetsValuesGet

Methods

(==) :: SpreadsheetsValuesGet -> SpreadsheetsValuesGet -> Bool

(/=) :: SpreadsheetsValuesGet -> SpreadsheetsValuesGet -> Bool

Data SpreadsheetsValuesGet

Methods

gfoldl :: (forall d b. Data d => c (d -> b) -> d -> c b) -> (forall g. g -> c g) -> SpreadsheetsValuesGet -> c SpreadsheetsValuesGet

gunfold :: (forall b r. Data b => c (b -> r) -> c r) -> (forall r. r -> c r) -> Constr -> c SpreadsheetsValuesGet

toConstr :: SpreadsheetsValuesGet -> Constr

dataTypeOf :: SpreadsheetsValuesGet -> DataType

dataCast1 :: Typeable (* -> *) t => (forall d. Data d => c (t d)) -> Maybe (c SpreadsheetsValuesGet)

dataCast2 :: Typeable (* -> * -> *) t => (forall d e. (Data d, Data e) => c (t d e)) -> Maybe (c SpreadsheetsValuesGet)

gmapT :: (forall b. Data b => b -> b) -> SpreadsheetsValuesGet -> SpreadsheetsValuesGet

gmapQl :: (r -> r' -> r) -> r -> (forall d. Data d => d -> r') -> SpreadsheetsValuesGet -> r

gmapQr :: (r' -> r -> r) -> r -> (forall d. Data d => d -> r') -> SpreadsheetsValuesGet -> r

gmapQ :: (forall d. Data d => d -> u) -> SpreadsheetsValuesGet -> [u]

gmapQi :: Int -> (forall d. Data d => d -> u) -> SpreadsheetsValuesGet -> u

gmapM :: Monad m => (forall d. Data d => d -> m d) -> SpreadsheetsValuesGet -> m SpreadsheetsValuesGet

gmapMp :: MonadPlus m => (forall d. Data d => d -> m d) -> SpreadsheetsValuesGet -> m SpreadsheetsValuesGet

gmapMo :: MonadPlus m => (forall d. Data d => d -> m d) -> SpreadsheetsValuesGet -> m SpreadsheetsValuesGet

Show SpreadsheetsValuesGet

Methods

showsPrec :: Int -> SpreadsheetsValuesGet -> ShowS

show :: SpreadsheetsValuesGet -> String

showList :: [SpreadsheetsValuesGet] -> ShowS

Generic SpreadsheetsValuesGet

Associated Types

type Rep SpreadsheetsValuesGet :: * -> *

Methods

from :: SpreadsheetsValuesGet -> Rep SpreadsheetsValuesGet x

to :: Rep SpreadsheetsValuesGet x -> SpreadsheetsValuesGet

GoogleRequest SpreadsheetsValuesGet

Associated Types

type Rs SpreadsheetsValuesGet :: *

type Scopes SpreadsheetsValuesGet :: [Symbol]

Methods

requestClient :: SpreadsheetsValuesGet -> Client (Rs SpreadsheetsValuesGet)

type Rep SpreadsheetsValuesGet

type Rep SpreadsheetsValuesGet = D1 (MetaData "SpreadsheetsValuesGet" "Network.Google.Resource.Sheets.Spreadsheets.Values.Get" "gogol-sheets-0.1.1-1pkXSdCGpV83QL9chaCos2" False) (C1 (MetaCons "SpreadsheetsValuesGet'" PrefixI True) ((:*:) ((:*:) ((:*:) (S1 (MetaSel (Just Symbol "_svgXgafv") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe Xgafv))) ((:*:) (S1 (MetaSel (Just Symbol "_svgValueRenderOption") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe Text))) (S1 (MetaSel (Just Symbol "_svgUploadProtocol") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe Text))))) ((:*:) (S1 (MetaSel (Just Symbol "_svgPp") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 Bool)) ((:*:) (S1 (MetaSel (Just Symbol "_svgAccessToken") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe Text))) (S1 (MetaSel (Just Symbol "_svgSpreadsheetId") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 Text))))) ((:*:) ((:*:) (S1 (MetaSel (Just Symbol "_svgUploadType") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe Text))) ((:*:) (S1 (MetaSel (Just Symbol "_svgBearerToken") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe Text))) (S1 (MetaSel (Just Symbol "_svgRange") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 Text)))) ((:*:) (S1 (MetaSel (Just Symbol "_svgDateTimeRenderOption") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe Text))) ((:*:) (S1 (MetaSel (Just Symbol "_svgMajorDimension") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe Text))) (S1 (MetaSel (Just Symbol "_svgCallback") NoSourceUnpackedness SourceStrict DecidedStrict) (Rec0 (Maybe Text))))))))

type Scopes SpreadsheetsValuesGet

type Scopes SpreadsheetsValuesGet = (:) Symbol "https://www.googleapis.com/auth/drive" ((:) Symbol "https://www.googleapis.com/auth/drive.readonly" ((:) Symbol "https://www.googleapis.com/auth/spreadsheets" ((:) Symbol "https://www.googleapis.com/auth/spreadsheets.readonly" ([] Symbol))))

type Rs SpreadsheetsValuesGet

type Rs SpreadsheetsValuesGet = ValueRange

Request Lenses

svgXgafv :: Lens' SpreadsheetsValuesGet (Maybe Xgafv)

V1 error format.

svgValueRenderOption :: Lens' SpreadsheetsValuesGet (Maybe Text)

How values should be represented in the output.

svgUploadProtocol :: Lens' SpreadsheetsValuesGet (Maybe Text)

Upload protocol for media (e.g. "raw", "multipart").

svgPp :: Lens' SpreadsheetsValuesGet Bool

Pretty-print response.

svgAccessToken :: Lens' SpreadsheetsValuesGet (Maybe Text)

OAuth access token.

svgSpreadsheetId :: Lens' SpreadsheetsValuesGet Text

The ID of the spreadsheet to retrieve data from.

svgUploadType :: Lens' SpreadsheetsValuesGet (Maybe Text)

Legacy upload protocol for media (e.g. "media", "multipart").

svgBearerToken :: Lens' SpreadsheetsValuesGet (Maybe Text)

OAuth bearer token.

svgRange :: Lens' SpreadsheetsValuesGet Text

The A1 notation of the values to retrieve.

svgDateTimeRenderOption :: Lens' SpreadsheetsValuesGet (Maybe Text)

How dates, times, and durations should be represented in the output. This is ignored if value_render_option is FORMATTED_VALUE.

svgMajorDimension :: Lens' SpreadsheetsValuesGet (Maybe Text)

The major dimension that results should use. For example, if the spreadsheet data is: `A1=1,B1=2,A2=3,B2=4`, then requesting `range=A1:B2,majorDimension=ROWS` will return `[[1,2],[3,4]]`, whereas requesting `range=A1:B2,majorDimension=COLUMNS` will return `[[1,3],[2,4]]`.

svgCallback :: Lens' SpreadsheetsValuesGet (Maybe Text)

JSONP