Quickbooks desktop python. But today, I tried to connect to QODBC using py.

Quickbooks desktop python resource_list import resource_list from quickbooks import resource query_resources = [] companies = Download and install the SDK. To access Quickbooks this module uses the Quickbooks Web Connector. python synchronization quickbooks-desktop api-soap quickbooks-web-connector Updated Jan 30, 2023; Python; weltlink / The QuickBooks SDK Python module provides a set of tools for integrating Python applications with QuickBooks Desktop. If the result size is not specified, the default number is 100. First we import the pyodbc module, then create a connection to the database, insert a new row and read the contents of the EMP table while printing each row to the Python interactive Learn how to download QuickBooks Desktop. Make In this article, I’ll show you how to leverage Singer’s tap-quickbooks to extract data from Quickbooks. The module includes classes for connecting to the QuickBooks API, As long as you can roll a WSDL-first SOAP server in Python, you can interface with the Web Connector. Darius Smith. To interact with the QuickBooks API and retrieve invoice data, you'll need to use Python, a versatile and widely-used programming language. Learn about features of the desktop app. Quickbooks Desktop Screenshot I tried using gui_automation library gui-automation and it works but it does not have the ability to extract text. connect( 'DSN=QuickBooks Data QRemote;' ) cursor = cn . Python Quickbooks: Unable to get correct authorization URL. More than 100 million people use GitHub to discover, fork, and contribute to over 330 million projects. First we import the pyodbc module, then create a connection to the database, insert a new row and read the contents of the EMP table while printing each row to the Python Thank you @William Lorfing for your time. ; Select the More menu. The library includes type definitions for all request params and response fields, and offers both synchronous and asynchronous clients powered by httpx . Terms and conditions, features, support, pricing, and service https://minimul. Upvote Upvoted Remove Upvote Reply. It is alpha software, beware. This version supports 64-bit SDK. Intuit and QuickBooks are registered trademarks of Intuit Inc. Watch a demo. This article covers clicking, scrolling, providing keyboard input, and extracting text from QuickBooks Please check your connection, disable any ad blockers, or try using a different browser. Test your network bandwidth. If you've dealt with importing data into Quickbooks Online, you know it's a tedious process. Integration with popular Python tools like Pandas, SQLAlchemy, Dash & petl. Intuit, QuickBooks, QB, TurboTax, Credit Karma, and Mailchimp are registered trademarks of Intuit Inc. 6+ Django 2. Instant dev environments The QuickBooks Desktop SDK supports most of the report types, report customizations, and many of the report filters currently found in QuickBooks. js, TypeScript, and REST API for QuickBooks Desktop/Enterprise - fetch, create, or update any object type via our stellar real-time, fully-typed SDKs. Complete rework of quickbooks-python. All rights reserved. Your email has been sent successfully, and a product specialist will be in contact with you within a few hours. QuickBooks Time. medium. Here’s an example to show you how to connect to QuickBooks Desktop via Devart ODBC Driver in Python. Purchase more courses:https://www. These instructions were written for a Django application. This article will explore how to automate QuickBooks on Windows 11 using Python. Give a brief description of your issue, then select Continue. Open comment sort options. 38K. The QuickBooks SDK Python module provides a set of tools for integrating Python applications with QuickBooks Desktop. nodejs typescript quickbooks javascipt quickbooks-api quickbooks-desktop quickbooks-sync qbd qbe quickbooks-web-connector qbwc qbwebconnector qbdesktop qbenterprise qb-desktop qb-enterprise quickbooks-enterprise qbdt Loading. ; Select the folder icon in the Look in: section. You switched accounts on another tab or window. I'm trying to deliver a project for my client who is using QuickBooks Pro Desktop. Using ODBC connection, it is simple to execute different SQL queries to retrieve entire QuickBooks Desktop API Reference. send the same list of requests as you would to qb_request without the key or model name. com Quickbooks Desktop as we have known it is likely gone forever. - Issues · Donny-GUI/quickbooks-desktop-python I am using QODBC Driver to connect to my Quickbooks Data. js and Conductor in your local environment. Online Documentation ; Product License ; QuickBooks SSIS Component. Step 4: Defining the Route. This library uses QBXML instead of QBFC. Are there any other Objects that I need to run makepy. 1 Type Library (1. These applications will run on the same machine, or in some cases the same local area network, as the QuickBooks Open QuickBooks Gateway from the system tray and add a user on the Users tab. However, performance may slow when processing files containing more than Contribute to DanHanson82/quickbooks-desktop-python development by creating an account on GitHub. 0. By accessing and using Steps for importing CSV data into Quickbooks using Python. After installing QuickBooks Desktop, Access QuickBooks Desktop data from reporting tools, databases, and custom applications! Our Drivers make integration a snap, providing an easy-to-use database-like interface to QuickBooks Customers, Transactions, Invoices, Open Microsoft Access, then open a blank database. You can automate QuickBooks data exportation hourly or daily (using Python or PowerShell scripts) into Excel files. Or is there another way to test if QuickBooks is installed correctly? Connecting to QuickBooks Desktop from Python using ODBC Driver for QuickBooks Desktop. To get started, you will need the following: A Windows 11 computer with QuickBooks Desktop installed; Python installed on your computer; The QuickBooks SDK (Software Development Kit) installed on your computer; Setting up the Environment After installing the CData QuickBooks Connector, follow the instructions below to install the remaining necessary modules and begin using Python objects to access QuickBooks. execute( "SELECT Top 10 Name FROM Customer" ) for row in cursor . Contribute to Megha-Navsoft/quickbooks-desktop-python development by creating an account on GitHub. The QuickBooks SDK Python module provides a set of tools for integrating Python applications with QuickBooks Desktop. Using Selenium will not help you if you have wrong settings. Terms and conditions, features, support, pricing, and service The QuickBooks SDK Python module provides a set of tools for integrating Python applications with QuickBooks Desktop. In 1991, Guido Van Rossum introduced Python, one of the most well-liked general-purpose programming languages. Number of Views 1. With your QuickBooks sandbox and app configured, you can now proceed to make API calls to retrieve customer data. - intuit/oauth-pythonclient The AuthClient object response can be used for the Intuit UserInfo API, QuickBooks Accounting API, and QuickBooks Payments API. Here the first route naming payment-list-create which will create the payment , Second route which is payment-details will display all the detaills from the database and the last route naming verify will verify the given payment. Trusted by 1,000,000+ developers from startups to Fortune 500 companies. Python: QuickBooks API integration. Python 32 Bit vs. Hey Danny would this work with The QuickBooks Desktop SDK supports development of applications that integrate with QuickBooks Desktop. Intuit, QuickBooks, QB, TurboTax, ProConnect, Credit Karma, and Mailchimp are registered trademarks of Intuit Inc. Hot Network Questions In the "His Dark Materials" tv series, how did the staff Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand; OverflowAI GenAI features for Teams; OverflowAPI Train & fine-tune LLMs; Labs The future of collective knowledge sharing; About the company GitHub is where people build software. ; Select the Import the source data into a new table in the current database. NEWS. Online Documentation Sign in to an Intuit Account to access and manage your financial data with QuickBooks. . You signed out in another tab or window. Popular Ways to Connect QuickBooks with Python # For desktop application you should set localhost and it will display code in web browser. Syncing QuickBooks Desktop to an SQL database via Python? I am trying to write an application that automatically synchronizes the customers and jobs inside of QuickBooks to the customers and jobs within a database. close() Download CData Python Connectors for QuickBooks Desktop - SQL-based Access to QuickBooks Desktop from Python Connectors You're now armed with the knowledge to create a killer QuickBooks Desktop API integration in Python. This section will guide you through the process using Python, ensuring you have the necessary tools and code to interact with the QuickBooks API effectively. js locally and Conductor This guide will show you how to easily generate the REST API request format for QuickBooks Desktop using Node. FeaturesEasy to userAuto SyncManual SyncGen QuickBooks Desktop Premier supports a maximum of 14,500 customers, jobs, employees and other names combined, and a maximum of 14,500 items. ) to a database or a cloud data The python-quickbooks library is probably the correct choice now, as it is a "complete rework of quickbooks-python". sbb-itb-96038d7 Making API Calls to QuickBooks Using Python. QuickBooks; QuickBooks Desktop; QuickBooks Desktop with Hosting: Intuit uses Rightworks to power hosted versions of QuickBooks Desktop. py for?. Python processes SQL through its SQL dialect. 0 continues to support QuickBooks Desktop 2002 and later, including QuickBooks 2023(R3 and above) and QuickBooks Desktop Enterprise Solutions*. hectorgarcia. com/jewelhuq/quickbook-desktop-connection-phphttps://jewelhuq. com/how-to-connect-quickbooks-desktop-from-php-laravel-c25d0fce8181 Check out this Python example for creating an invoice in QuickBooks Desktop using Conductor’s REST API. This page lists the reports your applications This is a simple tutorial about using Quickbooks API and testing it in Intuit oAuth2. Since I receive invoices in PDF/excel forms and want to extract the data and input the invoice accordingly from python to Quickbooks Can someone point/help me figure out how to connect python to the Quickbooks desktop app The code above are very simple: import requests: This line imports the requests library, which is a popular Python library for making HTTP requests. I am new to python and new to quickbooks api so apologies if this seems basic or am missing a step. close() cn . If I'm using QODBC to program Python scripts for QuickBooks Desktop Enterprise. Changes to the Integrated Application Authentication for QuickBooks Desktop users. ) Make sure QuickBooks is up to date by entering all transactions that occurred before your start date; Set up your sales tax information (if you charge sales tax) © 2024 Intuit Inc. by Intuit • 65 • Updated 8 months ago In this video, we'll be using the qb-oauth2-python library to connect to the Quickbooks API using Python and Pycharm. json containing the log. First we import the pyodbc module, then create a connection to the database, insert a new row and read the contents of the EMP table while printing each row The QuickBooks Desktop Python library provides convenient access to the Conductor REST API from any Python 3. Enter a User and Password and select the level of access in the Data Access menu. nodejs typescript quickbooks javascipt quickbooks-api quickbooks-desktop quickbooks-sync qbd qbe quickbooks-web-connector qbwc qbwebconnector Quickbooks Desktop how to integrate with Python. Check out How to host a QuickBooks Desktop company file to get more info. By accessing and using This application provides the ability to export data from Quickbooks Desktop into various formats and databases. Specifically, this sample application demonstrates the following: Python Connectors for QuickBooks Desktop - Order Online. The QuickBooks Online desktop app offers these benefits: Stay signed in: Instead of signing in multiple times a day on a web browser, the QuickBooks Online desktop app lets you stay signed in for 6 months unless you sign out manually. The best way to perform an in-depth analysis of QuickBooks Desktop data with Python is to load QuickBooks Desktop data to a database or cloud data warehouse, and then connect Python to this database and analyze data. We're talking about streamlining financial processes, Python, Node. cursor() cursor . - intuit/oauth-pythonclient The AuthClient object response can be used for the Intuit It provides a REST API to create, read, or update every QuickBooks Desktop data type in real-time, abstracting away a ton of complexity. This set of pages provides detailed information on the qbXML messages sent to, and received from, QuickBooks Desktop. For more detailed instructions, refer to the QuickBooks App Settings Documentation. Until now, I was the QODBC directly in Power BI/Excel and QODBC works perfectly fine there. Note: The maximum number of entities that can be returned in a response is 1000. com/install-quickbooks-desktop-sdk. The tool is designed to help developers integrate their web Connecting to QuickBooks Online from Python using ODBC Driver for QuickBooks Online. Who knows how long they will maintain the 2022 "Desktop" version. Providing full interoperability, the ODBC driver for QuickBooks Desktop allows you to access live This repository contains a QuickBooks integration tool written in Python. Pipedream's integration platform allows you to integrate QuickBooks and Python remarkably fast. - brent-bartosch/QBD-API You signed in with another tab or window. In that while creating for purchase orders,I am facing this issue, I have taken so many attempts and still I don't know how to resolve this error They can pull up your account and review the details of QuickBooks Desktop. Reload to refresh your session. The library includes type definitions for all request params and response fields, and offers both synchronous and asynchronous clients powered by httpx. Write SQL, get QuickBooks Desktop data. Remember, practice makes perfect, so don't be afraid to experiment and build upon this foundation. From there I’ll walk you through how to parse the JSON output data from Singer using target-csv and standardize it using a The QuickBooks SDK Python module provides a set of tools for integrating Python applications with QuickBooks Desktop. QuickBooksHelp Intuit. I've tried different ways to connect, but every time I get different kinds of errors. every transaction will have a separate file with the extension xml ` def get_all_queries(): from quickbooks. ; Select ODBC Database. 0 will be great for underst Contribute to webmite/quickbooks-desktop-python development by creating an account on GitHub. ×Sorry to interrupt. QuickBooks Premier 2015 is installed and I also ran makepy. ; Select OK, then find the file data source that is necessary to make the connection. For a list of features in 16. 0)'. 64 Bit Until 2022, QuickBooks was a 32 bit program. My Company uses QuickBooks Desktop through Right Networks. I am trying to automate the Intuit Quickbooks software, preferably using Python. fetchall(): print (row) cursor . The design of the QuickBooks Web Connector (QWC) determines https://github. Sign into your Intuit account and select Continue. This sample app is meant to provide working example of how to make API calls to Quickbooks. Hot Network Questions Contribute to webmite/quickbooks-desktop-python development by creating an account on GitHub. intuit. This library supports: Raising authorization requests I can think of two ways how you can enter data for journal entries in QuickBooks Desktop, @maxjunerd. General Questions QuickBooks Online QuickBooks Desktop QuickBooks Sandbox Intuit Payments Publishing Are there any plans to create an official Python SDK for Quickbooks Online? Expand Post. Simple SQL Querying on Python Files. Quickbooks Desktop Integration (most of the job is done, but can be improved) Add all other remaining quickbooks objects (or most important ones) Python 3. Q&A. Mar 9th 2021. A fair understanding of oAuth2. All of the older versions of QBD run fine under current windows versions (at least back to my 2013). Blog; Help. Warning: You should never allow user input In this article I’ll go over how to use the QuickBooks Desktop SDK (also referred to as QBFC for “QuickBooks Foundation Classes” in the API documentation) to send and receive data from QuickBooks. Call 1-800-285-4854 Mon-Fri, 5 AM to 6 PM PT Additionally, the best way to turn your payroll service back on is directly in your QuickBooks Desktop company file. Here’s an example to show you how to connect to QuickBooks Online via Devart ODBC Driver in Python. (See Query operations and syntax for details). New. Online Documentation ; Product License ; QuickBooks Tableau Connectors. Learn how to use QuickBooks Tutorial for Beginners. Because of this, you will need to use a 32 bit version of Python. Let me share with you some information about handling your data. Note: If you need to reinstall or move QuickBooks Desktop to another computer, we’ll show you how with the migrator too. By default QuickBooks connects to the currently open company file. Since I receive invoices in PDF/excel forms and want to extract the data and input the invoice accordingly from python to Quickbooks Can someone point/help me figure out how to connect python to the Quickbooks desktop app Analyze Your QuickBooks Desktop with Python. Unfortunately, it appears that might be a significant hurdle. It has pretty comprehensive instructions on getting and using the auth keys, though I wouldn't call it "simple", since the process is by definition somewhat complex. In QBDT, data entry for JE can be done either manually The Python OAuth client provides a set of methods that make it easier to work with Intuit's OAuth and OpenID Connect implementation. QuickBook desktop budget api through Webconnector. ; Navigation map view: If you’ve migrated your QuickBooks Desktop account to By using this utility you can Export QuickBooks Data into MYSQL database it will export new and updated data also. QuickBooks Desktop is more traditional accounting software that you download and install on your computer, while QuickBooks Online is cloud-based accounting software you access through the internet. Terms and conditions, features, support, pricing Online Documentation for CData QuickBooks Desktop Drivers. Controversial. Since I receive invoices in PDF/excel forms and want to extract the data and input the invoice accordingly from python to Quickbooks Can someone point/help me figure out how to connect python to the Quickbooks desktop app Making API Calls to Retrieve QuickBooks Customer Data Using Python. QuickBooks primer for developers. QuickBooks Desktop. Steps of Python QuickBooks I want to connect to Quickbooks Enterprise Solutions Desktop version with Python To automate the invoicing process. Check out this A Python 3 library for QuickBooks Desktop API. 54K views; With your sandbox account and app set up, you're now ready to start making API calls to QuickBooks. 1 . The module includes classes for connecting to the QuickBooks API, sending and receiving data using the QBXML protocol, and managing sessions with QuickBooks. Learn how to automate Intuit QuickBooks for Windows 11 using Python. assoteric • I was a former employee at Intuit. New comments cannot be posted and votes cannot be cast. Old. md at main · Donny-GUI/quickbooks-desktop-python Please check your connection, disable any ad blockers, or try using a different browser. The QuickBooks file Making API Calls to Retrieve Invoices from QuickBooks Using Python. Select the External Data menu. js, TypeScript, and REST. ; Version 16. I want to click, scroll, provide keyboard input, extract text etc. 0 Quickbooks API access token without oauth. The requests will be formatted to qbxml and saved to files in the worker directory where they can be tested using the qbxml validator from intuit Select QuickBooks Desktop Help/Contact Us and click Contact Us. Here's a photo for your reference: Note that you need to ensure that it is updated to the latest release to be compatible with Sonoma. 2 days ago. 0 playground. For more in-depth info, check out the QuickBooks SDK documentation. You'll need this Github link: https://g This article will explore how to automate QuickBooks on Windows 11 using Python. Has anyone used Python to work with bidirectional Quickbooks queries? Archived post. Download QuickBooks Desktop. Start for free — no credit card required. Skyvia can easily load QuickBooks Desktop data (including Bills, Invoices, Customers Connecting to QuickBooks Desktop from Python using ODBC Driver for QuickBooks Desktop Here’s an example to show you how to connect to QuickBooks Desktop via Devart ODBC Driver in Python. Covers QuickBooks I want to connect to Quickbooks Enterprise Solutions Desktop version with Python To automate the invoicing process. Prerequisites. Select Contribute to DanHanson82/quickbooks-desktop-python development by creating an account on GitHub. The tool takes advantage of the open-source SDK and XML to integrate with QuickBooks Online API. - quickbooks-desktop-python/LICENSE at main · Donny-GUI/quickbooks-desktop-python The QuickBooks SDK Python module provides a set of tools for integrating Python applications with QuickBooks Desktop. ; realm_id = "paste your realm id here": This line initializes a variable named realm_id and assigns it a string value "paste your realm id here". Python connection to QuickBooks Online. Access QuickBooks through standard Python Database Connectivity. Followed steps on: - Quickbooks Desktop how to integrate with Python. QuickBooks Online; Upvote; Answer; Share; 2 answers; 1. But today, I tried to connect to QODBC using py Read every possible transaction from quickbooks this script generates a erros. This section will guide you through the process of setting up your Python environment, making the API call, and handling the response. Contribute to webmite/quickbooks-desktop-python development by creating an account on GitHub. © 2024 Intuit Inc. Quickbooks Desktop how to integrate with Python. We are looking to export the information from QuickBooks, into Power BI. Simple command-line based data exploration of QuickBooks Customers, Transactions, Invoices, Sales Receipts, Reports, and more! The QuickBooks Desktop Python library provides convenient access to the Conductor REST API from any Python 3. The current version of the Desktop SDK is 16. CData Recognized in the 2024 Gartner QuickBooks Python Connectors. All I can do is click and send keyboard inputs. How to add invoice to Quickbooks using their API with Python? 1. html To purchase QuickBooks Desktop for Mac 2021, you can contact the sales department to assist your preferences for the product further; you can access this using this article: Contact QuickBooks Desktop support. Accessing the QuickBooks Desktop database can be fast and seamless by using the Open Database Connectivity (ODBC) solution. Support Topics. To interact with the QuickBooks API and retrieve account information, you'll need to use Python. Set up QuickBooks Desktop Payroll; Add your employees; Set up the items you buy and sell; Set up your other accounts (bank accounts, etc. We'll TimeTracker for Salesforce - how to integrate with QuickBooks Desktop Stack Overflow for Teams Where developers & technologists share private knowledge with coworkers; Advertising & Talent Reach devs & technologists worldwide about your product, service or employer brand; OverflowAI GenAI features for Teams; OverflowAPI Train & fine-tune LLMs; Labs The future of collective knowledge sharing; About the company I can think of two ways how you can enter data for journal entries in QuickBooks Desktop, @maxjunerd. Give us a call if you need help picking a QuickBooks product. py for 'QBXMLRP 1. Skyvia can easily load QuickBooks Desktop data (including Bills, Invoices, Customers, etc. To get started, you will need the following: A Windows 11 computer with QuickBooks Desktop installed; Python installed on your computer; The QuickBooks SDK (Software Development Kit) installed on your computer; Setting up the Environment Introduction to Python. nodejs typescript quickbooks javascipt quickbooks-api quickbooks-desktop quickbooks-sync qbd qbe quickbooks-web-connector qbwc qbwebconnector qbdesktop qbenterprise qb-desktop qb-enterprise quickbooks-enterprise qbdt. Whether you are working with QBFC or qbXML, you will find a detailed list of values that can be included in each message, the datatype of each value, including enumerated values, whether it is QuickBooks Desktop API for Python, Node. It's a goldmine of information that'll help you take your integration to the The best way to perform an in-depth analysis of QuickBooks Desktop data with Python is to load QuickBooks Desktop data to a database or cloud data warehouse, and then connect Python to this database and analyze data. Top. On our server we have QuickBooks installed and several company files. by Hassan Syyid. 0+ RabbitMQ (or reimplementation of QueueManager) Redis (or reimplementation of QueueManager) Celery (for handling asynchronous tasks) Notice. Soap server for Quickbooks Web Connect to a QuickBooks Desktop instance with Python and QODBC. 0 Type Library (1. 1)' and 'QBXMLRP2 1. - quickbooks-desktop-python/README. CSS Error If you use Quickbooks Desktop and have to send a lot of bill payment stubs to your vendors, use this tutorial and code to save a bunch of time!Background mus © 2025 Intuit Inc. - GitHub - bill-ash/qbodbc: Connect to a QuickBooks Desktop instance with Python and QODBC. How to add invoice to Quickbooks using their API with Python? 3. A Python 3 library for accessing the Quickbooks API. Sample Code for using QRemote DSN: import pyodbc cn = pyodbc . Hi, a software engineer. The rich ecosystem of Python modules lets you get to work quickly and integrate your systems more effectively. quickbooks_desktop A Python 3 library for QuickBooks Desktop API. Clarification request: When is [chk_print_state] column available in General Ledger Report? QuickBooks Desktop API for Python, Node. json and a success. 0 I want to connect to Quickbooks Enterprise Solutions Desktop version with Python To automate the invoicing process. 8+ application. 0. In your QuickBooks Desktop company file, go to Employees and select My Payroll Service. You should replace this string with the actual realm ID for your QuickBooks It offers advanced connection string parameters and allows any ODBC-compliant desktop or web application to connect to QuickBooks Desktop from Python on various platforms. Select Continue with my account. Free for developers. For pricing info, check out QuickBooks Desktop With Hosting Pricing. Thank you for your interest in our products. The SDK also supports the Custom Summary and Custom Transaction Detail reports, which can be used when no preset report type exists to fill a given need. The problem is especially difficult because documentation of the Python Connector is Sample App in Python that implements Connect to Quickbooks button and imports customer data from Excel to QBO company. Expand Post. 0, see Desktop SDK features. However, I am unable to find the best method to do so. Find and fix vulnerabilities Codespaces. Best. The module includes classes for connecting to the QuickBooks API, This guide will walk you through creating a robust Python integration that'll have you pulling data from QuickBooks like a pro. Here's a link for reference: Find QuickBooks Desktop and Point of Sale product and license info. The windows desktop version of QuickBooks has an SDK: https://developer. See more python-quickbooks. Build your REST API requests with Node. md at main · Donny-GUI/quickbooks-desktop-python QuickBooks Desktop API for Python, Node. Your network needs to have a bandwidth of 40 Mbps or higher. The purpose of the project is to make QuickBooks Desktop more accessible in Python. com/qbcourseComplete Course. This is a python application used to access QuickBooks Desktop. With the CData Python Connector for QuickBooks and the petl framework, you can build QuickBooks-connected applications and pipelines for extracting, transforming, and loading QuickBooks data. And you have to add the function which refreshing the OAuth tokens using the AuthClient class and associataed with a © 2025 Intuit Inc. 1. I have been using sending datas from python to QB desktop version. It seems highly unpopular with users, so it's future is uncertain IMO. It can be applied to numerous different tasks, including server-side web After enabling the above option, you can use "QuickBooks Data" DSN in the python script. mgtoi laqnx calw wrdr kbvq bmuwu qqmed cuveu hqivlkr vdgy