{"payload":{"feedbackUrl":"https://github.com/orgs/community/discussions/53140","repo":{"id":831988411,"defaultBranch":"main","name":"getCryptoValues","ownerLogin":"MarcoVando","currentUserCanPush":false,"isFork":false,"isEmpty":false,"createdAt":"2024-07-22T06:12:43.000Z","ownerAvatar":"https://avatars.githubusercontent.com/u/88511751?v=4","public":true,"private":false,"isOrgOwned":false},"refInfo":{"name":"","listCacheKey":"v0:1721628763.0","currentOid":""},"activityList":{"items":[{"before":"67652c0ae460b07c9037f603fc8594f944b9d99e","after":"6e7f8778423821929d91f7dbabf8801700c5a568","ref":"refs/heads/main","pushedAt":"2024-07-22T06:24:45.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"MarcoVando","name":"Marco Vandone","path":"/MarcoVando","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/88511751?s=80&v=4"},"commit":{"message":"Rename getPricePerf.js to getPricePerfomance.js","shortMessageHtmlLink":"Rename getPricePerf.js to getPricePerfomance.js"}},{"before":"a6cdefa0efe15055fa0fe376ad03ee7646e505c2","after":"67652c0ae460b07c9037f603fc8594f944b9d99e","ref":"refs/heads/main","pushedAt":"2024-07-22T06:23:26.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"MarcoVando","name":"Marco Vandone","path":"/MarcoVando","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/88511751?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"d662786a62863edcef6aaf73b27014abe7b54670","after":"a6cdefa0efe15055fa0fe376ad03ee7646e505c2","ref":"refs/heads/main","pushedAt":"2024-07-22T06:22:16.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"MarcoVando","name":"Marco Vandone","path":"/MarcoVando","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/88511751?s=80&v=4"},"commit":{"message":"Create getCryptoData.js","shortMessageHtmlLink":"Create getCryptoData.js"}},{"before":"40b76565bd17e9cee69acfcc109d106f45b7652f","after":"d662786a62863edcef6aaf73b27014abe7b54670","ref":"refs/heads/main","pushedAt":"2024-07-22T06:21:20.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"MarcoVando","name":"Marco Vandone","path":"/MarcoVando","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/88511751?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"a91968c00b3c2c8cfc0aff09a3c70a98c22ad9ab","after":"40b76565bd17e9cee69acfcc109d106f45b7652f","ref":"refs/heads/main","pushedAt":"2024-07-22T06:18:56.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"MarcoVando","name":"Marco Vandone","path":"/MarcoVando","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/88511751?s=80&v=4"},"commit":{"message":"Create getPricePerf.js\n\nAdded getPricePerfomance script","shortMessageHtmlLink":"Create getPricePerf.js"}},{"before":"ecd21b11b8a31308b37e892cabed594c4568ef90","after":"a91968c00b3c2c8cfc0aff09a3c70a98c22ad9ab","ref":"refs/heads/main","pushedAt":"2024-07-22T06:17:12.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"MarcoVando","name":"Marco Vandone","path":"/MarcoVando","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/88511751?s=80&v=4"},"commit":{"message":"Update README.md","shortMessageHtmlLink":"Update README.md"}},{"before":"6b32d7574687030475772d44f9fd6bdaf62d1016","after":"ecd21b11b8a31308b37e892cabed594c4568ef90","ref":"refs/heads/main","pushedAt":"2024-07-22T06:14:57.000Z","pushType":"push","commitsCount":1,"pusher":{"login":"MarcoVando","name":"Marco Vandone","path":"/MarcoVando","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/88511751?s=80&v=4"},"commit":{"message":"Create getSingleCrypto.js\n\nParameter Check:\r\n\t•\tEnsure the coin parameter is provided by the user. If not, return an error message.\r\n\t2.\tURL Construction:\r\n\t•\tDefine the base URL for the /v1/tools/price-conversion endpoint.\r\n\t3.\tHeaders and Options:\r\n\t•\tDefine the headers including the API key and content type.\r\n\t•\tSet muteHttpExceptions to true to handle errors gracefully.\r\n\t4.\tQuery Parameters:\r\n\t•\tConstruct the query string with the parameters object. This ensures the request URL is correctly formed.\r\n\t5.\tError Handling:\r\n\t•\tUse a try-catch block to handle potential errors from the UrlFetchApp.fetch request.\r\n\t•\tCheck if the API response contains an error, and if so, return the error message.\r\n\t6.\tExtracting Data:\r\n\t•\tExtract the quote.USD.price from the JSON response if no errors are encountered.\r\n\r\nUsage Example:\r\nReplace \"BTC\" with the desired cryptocurrency symbol. Make sure to replace the API key with your actual CoinMarketCap API key.\r\n\r\nTo call this function from your Google Sheets, you can use:\r\n=GETSINGLECRYPTODATA(\"BTC\")","shortMessageHtmlLink":"Create getSingleCrypto.js"}},{"before":null,"after":"6b32d7574687030475772d44f9fd6bdaf62d1016","ref":"refs/heads/main","pushedAt":"2024-07-22T06:12:43.000Z","pushType":"branch_creation","commitsCount":0,"pusher":{"login":"MarcoVando","name":"Marco Vandone","path":"/MarcoVando","primaryAvatarUrl":"https://avatars.githubusercontent.com/u/88511751?s=80&v=4"},"commit":{"message":"Initial commit","shortMessageHtmlLink":"Initial commit"}}],"hasNextPage":false,"hasPreviousPage":false,"activityType":"all","actor":null,"timePeriod":"all","sort":"DESC","perPage":30,"cursor":"Y3Vyc29yOnYyOpK7MjAyNC0wNy0yMlQwNjoyNDo0NS4wMDAwMDBazwAAAASFbnqy","startCursor":"Y3Vyc29yOnYyOpK7MjAyNC0wNy0yMlQwNjoyNDo0NS4wMDAwMDBazwAAAASFbnqy","endCursor":"Y3Vyc29yOnYyOpK7MjAyNC0wNy0yMlQwNjoxMjo0My4wMDAwMDBazwAAAASFbFXO"}},"title":"Activity · MarcoVando/getCryptoValues"}