Knife | share without considering the 140 character limit

I hope you guys are having a wonderful day.

I have set up a webhook in my woocommerce that sends JSON data to Google sheets. The webhook has been working great for months now, just today, I am having some trouble with it. I have tracked the issue to be in google sheets receiving the JSON data, but I don't know why this is happening.

Let me explain.

https://docs.google.com/spreadsheets/d/18G-yVDjYeccl6kznpZgSuRTysRMAu57pwY2oGf6-KWI/edit?usp=sharing

This is the google sheet, when it gets Woocommerce JSON data, it populates a new row.

The problem

Sometimes google sheets doesn't populate the row upon receiving a new order. The problem doesn't lie with woocommerce, because I have checked woocommerce with reqbin and the webhook fires with every order.

Furthermore, when I send requests from reqbin.com to my sheet, the sheet performs the operation successfully 5-6 out of 10 times. Other times it shows an error.

The Error

The error is due to google sheets not being able to parse JSON data, because the JSON data it receives 5 out of 10 times is not proper JSON data. Other 5 times, it is just as it should be. I have put a catch statement if the sheet is unable to parse JSON. Instead of appending new row with the parsed data, it appends the raw received data to the sheet.

It is clear now that there is some issue with google sheets handling that JSON data because when the same data is sent from reqbin.com to webhook.site, it is perfectly as it should be 10/10 times.

How to reproduce the issue

• Open this google sheet. https://docs.google.com/spreadsheets/d/18G-yVDjYeccl6kznpZgSuRTysRMAu57pwY2oGf6-KWI/edit?usp=sharing
• Open reqbin.com and webhook.site, and send the following JSON from reqbin.com to webhook.site 10 times to see if any kind of error occurs.

{ "id": 47222, "parent_id": 0, "status": "processing", "currency": "PKR", "version": "5.1.0","prices_include_tax": false, "date_created": "2021-06-10T01:23:46", "date_modified": "2021-06-10T01:23:46", "discount_total": "0", "discount_tax": "0", "shipping_total": "150", "shipping_tax": "0", "cart_tax": "0", "total": "1850", "total_tax": "0", "customer_id": 0, "order_key": "wc_order_7gIuR7px6MX9C", "billing": { "first_name": "Name", "last_name": "", "company": "", "address_1": "Address", "address_2": "", "city": "City", "state": "", "postcode": "", "country": "PK", "email": "email@email.com", "phone": "1234" }, "shipping": { "first_name": "Name", "last_name": "", "company": "", "address_1": "Address", "address_2": "", "city": "City", "state": "", "postcode": "", "country": "Country" }, "payment_method": "cod", "payment_method_title": "Cash on delivery", "transaction_id": "", "customer_ip_address": "8.8.8.8", "customer_user_agent": "Mozilla/5.0 (Linux; Android 11; M2102J20SG) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.88 Mobile Safari/537.36", "created_via": "checkout", "customer_note": "", "date_completed": null, "date_paid": null, "cart_hash": "64d834c72eecc8e32b9d83fd67d10d9c", "number": "47222", "meta_data": [ { "id": 869388, "key": "_shipping_calculator", "value": "" }, { "id": 869389, "key": "is_vat_exempt", "value": "no" }, { "id": 869391, "key": "_wfacp_report_data", "value": { "wfacp_total": "0.00" } }, { "id": 869392, "key": "_woofunnel_cid", "value": "4" }, { "id": 869393, "key": "_wfacp_post_id", "value": "24852" }, { "id": 869394, "key": "_wfacp_source", "value": "https://website.com/checkouts/checkout-page/" }, { "id": 869395, "key": "_wfacp_timezone", "value": "Asia/Karachi" }, { "id": 869396, "key": "order_comments", "value": "" }, { "id": 869412, "key": "_new_order_email_sent", "value": "true" }, { "id": 869424, "key": "_woofunnel_custid", "value": "4" }, { "id": 869425, "key": "_pys_purchase_event_fired", "value": "1" }, { "id": 869426, "key": "_wfob_stats_ids", "value": [] }, { "id": 869427, "key": "_wfocu_thankyou_visited", "value": "yes" } ], "line_items": [ { "id": 35114, "name": "MTECH Ultra Resilient Knife", "product_id": 11074, "variation_id": 0, "quantity": 1, "tax_class": "", "subtotal": "1700", "subtotal_tax": "0", "total": "1700", "total_tax": "0", "taxes": [], "meta_data": [], "sku": "", "price": 1700, "parent_name": null } ], "tax_lines": [], "shipping_lines": [ { "id": 35115, "method_title": "Fast Shipping (2-4 Days)", "method_id": "flat_rate", "instance_id": "1", "total": "150", "total_tax": "0", "taxes": [], "meta_data": [ { "id": 275053, "key": "Items", "value": "MTECH Ultra Resilient Knife × 1", "display_key": "Items", "display_value": "MTECH Ultra Resilient Knife × 1" } ] } ], "fee_lines": [], "coupon_lines": [], "refunds": [], "date_created_gmt": "2021-06-09T20:23:46", "date_modified_gmt":"2021-06-09T20:23:46", "date_completed_gmt": null, "date_paid_gmt": null, "currency_symbol": "₨","_links": { "self": [ { "href": "https://website.com/wp-json/wc/v3/orders/47222" } ],"collection": [ { "href": "https://website.com/wp-json/wc/v3/orders" } ] } }

• Now send the same data to the following google sheet to see if it appends the row correctly each time.

https://script.google.com/macros/s/AKfycbxupm9bje86F4PQQkyys_LWtXs_kj279R0ipgnZ-cLd7aiEADf1AN_prhk28vOPW9JsRQ/exec

How do I solve the issue? Please let me know if you need any more information. Thanks.

Edit:

Instead of getting a full JSON body like mentioned above, the google sheets seems to be getting the following JSON.

I am trying to make my bot that sends a random picture from an array (list) of pictures that I have on my computer. However, when I try to create an embed to send the image it says:

Apologies for asking a fairly common question, I have been looking all over and can't find a solution that fixes my problem.

I am using Firesharp, and trying to deserialize a Json object that Firebase returns into a class with a nested list.

I have a table in Excel that show which weapon where used to commit murder per year.

I want to read the data and plot it as a line plot with multiple lines:

However my code only gives me a gibberish graph:

This is my code:

I am writing a parser bot for Steam that will keep track of which items come and go from a Steam user's inventory. I wrote a code that gets all the user's items and returns in the form of a dictionary with a nested list, where KEY = USER NAME, VALUE = ITEM NAME AND ITS QUANTITY. Now I need to compare Data1 and Data2 (updated data).

I want to make a graph for each value of a variable in my dataframe, and then pass that value through to the graph as the title. I think the best way to do this is by using the apply() family of functions, but i'm a bit of a novice and can't figure out how to do that.

For example, say I have this dataframe:

I need to measure tumour volumes before and after a treatment. I want to construct the recording of the volumes by date efficiently and then analyse the tumour doubling time (the time the tumour takes to double in volume) using Pandas or similar. I am a surgeon and treat acoustic neuromas with Gamma Knife radiosurgery.The tumours typically grow at 1 to 2 mm each year in diameter. They are usually followed up with MRI scans until they show growth (in the UK) and are treated and are then followed up by MRI scans for 10 years at least.

I'm sure the data collection is relatively simple but want to optimise it for efficiency afterwards. I was thinking of just using Excel and then importing the CSV into Pandas. The spreadsheet needs to be simple because it will be on a network drive within the hospital accessible from any PC for a number of people to do the volumetric assessment. This is done by drawing around the tumour on individual slices of the MRI scan and then getting the MRI scan to compute the volume of the regions of interest.

I am fairly novice at Python and Pandas. The complexity for me will be to do the datetime calculations to look at pre-treatment growth, and then post treatment growth and calculate volume doubling times.

I need to do this for about 250 patients so the time-consuming element is the volumetric assessment. On average there will be 3 to 4 pre-treatment scans and up to 10 post-treatment scans, so the data frame will be 250 records with about 15 pairs of date and volume paired columns, or similar. Any suggestions welcome. I was just going to do it in FileMaker pro but I don't have a site license et cetera et cetera.

Forgive me if the title is a bit incorrect, I'm very new to Python's Classes and don't exactly know what the names of it's various intricacies. Best guess!

Hello SO! I'm working on a little example project and have run into a roadblock. Currently I'm attempting to create a basic combat tracker of sorts for a tabletop game. My current goal is to create a system where, based off of user inputs, one can raise or lower the HP for a preset object belonging to the class 'Entity' by simply typing in the name of the specific entity and the corresponding number.

For example, if orkBoy's Wounds (aka HP) were set to 12 by default and you wanted to increase it to 15, you would type in:

orkBoy 3

Or if you wished to decrease it by 2:

orkBoy -2

While the system works perfectly if you directly reference the object in the code, I am having trouble referencing the object through the user's input string due to a str Attribute Error (AttributeError: 'str' object has no attribute 'woundChange'). I will place the code below, including a try/except that Tries and fails at what I want to accomplish, and an Exception that provides an unsatisfactory but successful 'solution'.

When I try to export my pandas data frame to excel only one row exports.

The data base is created during a large loop which basically gives the output: