Ki|XSrSSKrSSKJr SSKJrJrJrJrJ r J r J r J r J r Jr SSKJr SSKJr SSKJrJr SS KJrJr SS KJrJrJrJrJrJrJ r J!r!J"r"J#r#J$r$ SS K%J&r&J'r'J(r( \ \)\ \\)\*\+\,\\)44r-\ \\ \)\\4\ \)\ \)\\44\ \)\ \)\\\)44\ \)\ \)\\\)\ \)\)4444r."S S 5r/"SS\/5r0\ \/r1g)z{ gspread.http_client ~~~~~~~~~~~~~~ This module contains HTTPClient class responsible for communicating with Google API. N) HTTPStatus) IOAnyDictListMappingMutableMappingOptionalTupleTypeUnion) Credentials)AuthorizedSession)ResponseSession)APIErrorUnSupportedExportFormat) DRIVE_FILES_API_V3_URLDRIVE_FILES_UPLOAD_API_V2_URLSPREADSHEET_BATCH_UPDATE_URLSPREADSHEET_SHEETS_COPY_TO_URLSPREADSHEET_URLSPREADSHEET_VALUES_APPEND_URL"SPREADSHEET_VALUES_BATCH_CLEAR_URL#SPREADSHEET_VALUES_BATCH_UPDATE_URLSPREADSHEET_VALUES_BATCH_URLSPREADSHEET_VALUES_CLEAR_URLSPREADSHEET_VALUES_URL) ExportFormatconvert_credentialsquotec\rSrSrSrS4S\S\\SS4SjjrS5Sjr S \\ \ \ \ \ 44SS4S jr S6S \S \S \\S\\S\\\\4S\S\\\\4S\4SjjrS\S\\\\4S\4SjrS7S\S\S \\S\\\\4S\4 SjjrS\S\S \S\\\\4S\4 SjrS\S\S\4SjrS7S\S \\S\\\\4S\4SjjrS4S\S\S \\S\4SjjrS4S\S\\S \\S\4SjjrS4S\S\\\\4S\4SjjrS4S\S \\S\4Sjjr S\S \!S!\S\4S"jr"S4S\S \\S\\\44S#jjr#S\S\4S$jr$\%RL4S%\S&\S\4S'jjr'S8S%\S(\\S)\\S*\\S+\(S,\\S-\(S\4S.jjr)S%\S\\*\\ \\(444S/jr+S%\S0\SS4S1jr,S%\S\ \\4S\4S2jr-S3r.g)9 HTTPClient9aAn instance of this class communicates with Google API. :param Credentials auth: An instance of google.auth.Credentials used to authenticate requests created by either: * gspread.auth.oauth() * gspread.auth.oauth_from_dict() * gspread.auth.service_account() * gspread.auth.service_account_from_dict() :param Session session: (Optional) An OAuth2 credential object. Credential objects created by `google-auth `_. You can pass you own Session object, simply pass ``auth=None`` and ``session=my_custom_session``. This class is not intended to be created manually. It will be created by the gspread.Client class. NauthsessionreturnczUbX lO*[U5Ul[UR5UlSUlgN)r'r!r&rtimeout)selfr&r's fC:\Users\julio\OneDrive\Documentos\Trabajo\Ideas Frescas\venv\Lib\site-packages\gspread/http_client.py__init__HTTPClient.__init__Ms0  "L%8%>DI,TYY7DLDH cSSKJn URRU"UR55 URR R SSURR-05 g)Nr)Request Authorizationz Bearer %s)google.auth.transport.requestsr2r&refreshr'headersupdatetoken)r,r2s r-loginHTTPClient.loginVsJ: '$,,/0 ##_kDIIOO6S$TUr0r+cXlg)zHow long to wait for the server to send data before giving up, as a float, or a ``(connect timeout, read timeout)`` tuple. Use value ``None`` to restore default timeout Value for ``timeout`` is in seconds (s). N)r+)r,r+s r- set_timeoutHTTPClient.set_timeout]s  r0methodendpointparamsdatajsonfilesr6c URRUUUUUUUURS9nUR(aU$[ U5e)N)r>urlrBr@rArCr6r+)r'requestr+okr) r,r>r?r@rArBrCr6responses r-rFHTTPClient.requesthsR<<''LL(   ;;O8$ $r0idbodycRURS[U-US9nUR5$)aLower-level method that directly calls `spreadsheets/:batchUpdate `_. :param dict body: `Batch Update Request body `_. :returns: `Batch Update Response body `_. :rtype: dict .. versionadded:: 3.0 postrB)rFrrB)r,rJrKrs r- batch_updateHTTPClient.batch_updates) LL!=!BL Nvvxr0rangecl[U[U54-nURSXSUS9nUR5$)aLower-level method that directly calls `PUT spreadsheets//values/ `_. :param str range: The `A1 notation `_ of the values to update. :param dict params: (optional) `Values Update Query parameters `_. :param dict body: (optional) `Values Update Request body `_. :returns: `Values Update Response body `_. :rtype: dict Example:: sh.values_update( 'Sheet1!A2', params={ 'valueInputOption': 'USER_ENTERED' }, body={ 'values': [[1, 2, 3]] } ) .. versionadded:: 3.0 putr@rBrr"rFrBr,rJrRr@rKrErOs r- values_updateHTTPClient.values_updates6:%E%L'99 LLL >vvxr0cl[U[U54-nURSXSUS9nUR5$)awLower-level method that directly calls `spreadsheets//values:append `_. :param str range: The `A1 notation `_ of a range to search for a logical table of data. Values will be appended after the last row of the table. :param dict params: `Values Append Query parameters `_. :param dict body: `Values Append Request body `_. :returns: `Values Append Response body `_. :rtype: dict .. versionadded:: 3.0 rMrU)rr"rFrBrWs r- values_appendHTTPClient.values_appends6,r5<.@@ LL$L ?vvxr0cn[U[U54-nURSU5nUR5$)aLower-level method that directly calls `spreadsheets//values:clear `_. :param str range: The `A1 notation `_ of the values to clear. :returns: `Values Clear Response body `_. :rtype: dict .. versionadded:: 3.0 rM)rr"rFrB)r,rJrRrErOs r- values_clearHTTPClient.values_clears2+b%,-?? LL %vvxr0cV[U-nURSXBUS9nUR5$)aLower-level method that directly calls `spreadsheets//values:batchClear` :param dict params: (optional) `Values Batch Clear Query parameters `_. :param dict body: (optional) `Values Batch Clear request body `_. :rtype: dict rMrU)rrFrB)r,rJr@rKrErOs r-values_batch_clearHTTPClient.values_batch_clears-125 LL$L ?vvxr0cj[U[U54-nURSXCS9nUR5$)aLower-level method that directly calls `GET spreadsheets//values/ `_. :param str range: The `A1 notation `_ of the values to retrieve. :param dict params: (optional) `Values Get Query parameters `_. :returns: `Values Get Response body `_. :rtype: dict .. versionadded:: 3.0 getr@rV)r,rJrRr@rErOs r- values_getHTTPClient.values_gets4%E%L'99 LLL 3vvxr0rangescfUc0nX#S'[U-nURSXCS9nUR5$)aLower-level method that directly calls `spreadsheets//values:batchGet `_. :param list ranges: List of ranges in the `A1 notation `_ of the values to retrieve. :param dict params: (optional) `Values Batch Get Query parameters `_. :returns: `Values Batch Get Response body `_. :rtype: dict rhrdre)rrFrB)r,rJrhr@rErOs r-values_batch_getHTTPClient.values_batch_gets= >F!x*R/ LLL 3vvxr0cT[U-nURSX2S9nUR5$)aLower-level method that directly calls `spreadsheets//values:batchUpdate `_. :param dict body: (optional) `Values Batch Update Request body `_. :returns: `Values Batch Update Response body `_. :rtype: dict rMrN)rrFrB)r,rJrKrErOs r-values_batch_updateHTTPClient.values_batch_updates+2B6 LLL 0vvxr0cT[U-nURSX2S9nUR5$)zA method stub that directly calls `spreadsheets.get `_.rdrerrFrBr,rJr@rErOs r-spreadsheets_getHTTPClient.spreadsheets_gets)" LLL 3vvxr0sheet_iddestination_spreadsheet_idc^[X4-nSU0nURSXES9nUR5$)zLower-level method that directly calls `spreadsheets.sheets.copyTo `_.destinationSpreadsheetIdrMrN)rrFrB)r,rJrtrurErKrOs r-spreadsheets_sheets_copy_to&HTTPClient.spreadsheets_sheets_copy_tos8-~=*,FG LLL 0vvxr0cbUcSS0n[U-nURSX2S9nUR5$)aSimilar to :method spreadsheets_get:`gspread.http_client.spreadsheets_get`, get the spreadsheet form the API but by default **does not get the cells data**. It only retrieve the the metadata from the spreadsheet. :param str id: the spreadsheet ID key :param dict params: (optional) the HTTP params for the GET request. By default sets the parameter ``includeGridData`` to ``false``. :returns: The raw spreadsheet :rtype: dict includeGridDatafalserdrerprqs r-fetch_sheet_metadataHTTPClient.fetch_sheet_metadatas: >'1F" LLL 3vvxr0c~[SRU5-nSSSS.nURSX#S9nUR5$)zGet the metadata from the Drive API for a specific file This method is mainly here to retrieve the create/update time of a file (these metadata are only accessible from the Drive API). z/{}Tz id,name,createdTime,modifiedTime)supportsAllDrivesincludeItemsFromAllDrivesfieldsrdre)rformatrFrB)r,rJrEr@ress r-get_file_drive_metadata"HTTPClient.get_file_drive_metadata5sI %u||B'77"&)-8  ll5#l5xxzr0file_idrcU[;a[eSR[U5nSU0nUR SX4S9nUR $)aoExport the spreadsheet in the given format. :param str file_id: The key of the spreadsheet to export :param str format: The format of the resulting file. Possible values are: * ``ExportFormat.PDF`` * ``ExportFormat.EXCEL`` * ``ExportFormat.CSV`` * ``ExportFormat.OPEN_OFFICE_SHEET`` * ``ExportFormat.TSV`` * ``ExportFormat.ZIPPED_HTML`` See `ExportFormat`_ in the Drive API. :type format: :class:`~gspread.utils.ExportFormat` :returns bytes: The content of the exported file. .. _ExportFormat: https://developers.google.com/drive/api/guides/ref-export-formats z {}/{}/exportmimeTyperdre)r rrrrFcontent)r,rrrEr@rOs r-exportHTTPClient.exportGsK0  %) )##$:GD(&1 LLL 3yyr0 email_address perm_typerolenotify email_message with_linkcSR[U5nUUUS.n SS0n US:XaX)S'O4US;a X)S'XZS'XjS 'O!US :XaO[S RU55eURS XU S 9$)aCreates a new permission for a file. :param str file_id: a spreadsheet ID (aka file ID). :param email_address: user or group e-mail address, domain name or None for 'anyone' type. :type email_address: str, None :param str perm_type: (optional) The account type. Allowed values are: ``user``, ``group``, ``domain``, ``anyone`` :param str role: (optional) The primary role for this user. Allowed values are: ``owner``, ``writer``, ``reader`` :param bool notify: Whether to send an email to the target user/domain. Default ``True``. :param str email_message: (optional) An email message to be sent if ``notify=True``. :param bool with_link: Whether the link is required for this permission to be active. Default ``False``. :returns dict: the newly created permission Examples:: # Give write permissions to otto@example.com gc.insert_permission( '0BmgG6nO_6dprnRRUWl1UFE', 'otto@example.org', perm_type='user', role='writer' ) # Make the spreadsheet publicly readable gc.insert_permission( '0BmgG6nO_6dprnRRUWl1UFE', None, perm_type='anyone', role='reader' ) {}/{}/permissions)typerwithLinkrtruedomain>usergroup emailAddresssendNotificationEmail emailMessageanyonezInvalid permission type: {}rM)rBr@)rr ValueErrorrF) r,rrrrrrrrEpayloadr@s r-insert_permissionHTTPClient.insert_permissionisd"(()?I!     -H  + +&3N #.4* +%2> " ( " :AA)LM M||FCf|EEr0cSR[U5nSSS.nSn/nUbTU(aXCS'URSX#S 9R5nUR US 5 UR S S5nUbMTU$) z`Retrieve a list of permissions for a file. :param str file_id: a spreadsheet ID (aka file ID). rTznextPageToken,permissions)rrN pageTokenrdre permissions nextPageToken)rrrFrBextendrd)r,rrEr@r8rrOs r-list_permissionsHTTPClient.list_permissionss "(()?I"&1   &+{# UC 7<<>A   q/ 0EE/40Er0 permission_idcXSR[X5nSS0nURSX4S9 g)zDeletes a permission from a file. :param str file_id: a spreadsheet ID (aka file ID.) :param str permission_id: an ID for the permission. z{}/{}/permissions/{}rTdeletereN)rrrF)r,rrrEr@s r-remove_permissionHTTPClient.remove_permissions5 %++ "G 248 Xs 2r0c [U[5(aURS5nSS0nSR[U5nUR SUUSSSS.US 9nUR 5$) amImports data into the first page of the spreadsheet. :param str data: A CSV string of data. Example: .. code:: # Read CSV file contents content = open('file_to_import.csv', 'r').read() gc.import_csv(spreadsheet.id, content) .. note:: This method removes all other worksheets and then entirely replaces the contents of the first worksheet. zutf-8z Content-Typeztext/csvz{}/{}rTmediaT) uploadTypeconvertr)rAr@r6) isinstancestrencoderrrFrB)r,rrAr6rErs r- import_csvHTTPClient.import_csvsw* dC ;;w'D!:.nn:GDll  %%)   xxzr0)r&r'r+r*)r(N)NNNNN)NN)TNF)/__name__ __module__ __qualname____firstlineno____doc__rr rr.r9r floatr r<r ParamsTypebytesrrFileTyper rrFrPrXr[r^rarfrrjrmrrintrxr}rr PDFrboolrrrrr__static_attributes__r0r-r$r$9s)&I[I8G3DIPTIV 8E%ue|9L2L,M#N SW (, $,06:%%%$ % uo % wsCx() %%.c23% %4 s (7383D*E # "(,,0  $  wsCx()  B!+5=EgcSVhFW=X $ s 3 3  (,,0  $wsCx()  "CG!+3J+? "JN#Cy2::2F (<@  %gc3h&78   30DPS !$BE 7;' 3 c ,##$2>1A1A c 3 e P'+GFGF }GFC= GF sm GF  GF }GFGF GFRT#uS$Y?O:O5P0Q6 3 3S 3T 3'#'U3:->'3'r0r$c^\rSrSr%Sr\R \R/r\ \\ S'Sr \ \ S'Sr \ \ S'S\S \S \4U4S jjrS rU=r$) BackOffHTTPClientiaBackOffHTTPClient is a http client with exponential backoff retries. In case a request fails due to some API rate limits, it will wait for some time, then retry the request. This can help by trying the request after some time and prevent the application from failing (by raising an APIError exception). .. Warning:: This HTTPClient is not production ready yet. Use it at your own risk ! .. note:: To use with the `auth` module, make sure to pass this backoff http client using the ``http_client`` parameter of the method used. .. note:: Currently known issues are: * will retry exponentially even when the error should raise instantly. Due to the Drive API that raises 403 (Forbidden) errors for forbidden access and for api rate limit exceeded._HTTP_ERROR_CODESr _NR_BACKOFF _MAX_BACKOFFargskwargsr(c>^S[S[[[4S[S[4U4Sjjn[ T T]"U0UD6$![anURnURnT=RS- sl [STR-TR5nU"XVU5SLa6[R"U5 TR "U0UD6nS Tl UsSnA$UeSnAff=f) Ncodeerrorwaitr(c>SU;a$U[R:XaUSSSS:XagUTR;=(d U[R:=(a UTR:*$)Nerrorsrr usageLimitsT)r FORBIDDENrINTERNAL_SERVER_ERRORr)rrrr,s r- _should_retry0BackOffHTTPClient.request.._should_retry(ss 5 J000h*84 E...<:;;;,$+++ ,r0rTr)rrrrrsuperrFrrrrminrtimesleep) r,rrrerrrrrrH __class__s ` r-rFBackOffHTTPClient.request&s , ,38$ , ,  ,2 7?D3F3 3 88DIIE    ! q$***D,=,=>DT$/47 4  <<88$% I) s$A C$ B CC$CC$)r)rrrrrrREQUEST_TIMEOUTTOO_MANY_REQUESTSrr__annotations__rrrrrrFr __classcell__)rs@r-rrse*6 ""$$+tJ'KL#1S1C1H11r0r)2rrhttprtypingrrrrrr r r r r google.auth.credentialsrr4rrequestsrr exceptionsrrurlsrrrrrrrrrrrutilsr r!r"rrrrrrr$rHTTPClientTyperr0r-rs"    0<&9    <; C%S$tCy0P*Q!RR S  sBsG|$sE#r#w,//0sE#r#w"3445sE#r#w^CH5M"MNNO Q HHVS Slj!r0