ehp | Easy Html Parser is an AST generator | Parser library

I'm trying to use IMPORTJSON to import some data from:

https://templeosrs.com/api/player_stats.php?player=Mikael&date=1639587712

to my google spreadsheet. For some columns, like "Ehp", I can get the value just fine with

=VALUE(QUERY(TRANSPOSE(IMPORTJSON(C5)), "select Col2 where Col1 = 'Ehp'"))

where C5 is just a cell with the link above in it. But this doesn't seem to work for any column that has an underscore in it, like "Ehp_rank".

I should say I understand nothing about how any of this works, I'm doing everything by looking at examples I found, then just trial and error. Can someone help me import columns with an underscore?

Also, I'd like to import the "Username", but it's inside that info block and I can't seem to get it right. I've tried "info.Username", changing Col2/1 to Col3/2, but no sucess.

In TTN they are no longer supporting large decoders.

I know what the decoder needs to be in TTN, it is in my DECODER function, but dont know how to execute it in the function node.

If you use inject Payload [1,2,3] RAW, it injects the raw payload that is msg.payload.payload.uplink_message.frm_payload into the decoder.

The DECODER needs to decode the raw payload and output it in msg.payload.uplink_message.decoded_payload

If you use inject Payload [1,2,3] Decoded in the flow you see how the end result needs to look like and the decoded msg.payload.uplink_message.decoded_payload

I am still learning JavaScript.

The code in the function node

Three tables in my model.py - Account, withdraw, taxDetails. I have a filed total amount (total_amnt_WoP) in the account table. Scenario is,  when I will try to withdraw an amount, it will reduce the total amount and also reduce some tax from it (10% of withdraw amount) and it will be saved in taxDetails table every time. I was trying to store total tax in the table.

In my case, it works fine (save the tax in taxDetails table) for the first time withdraw. But when I was trying to withdraw in second time, it gets:

Our version of SAP (ECC6 EHP 0) does not have the FM ZRFC_READ_TABLE2. We created a copy and called it ZFM_INTERNAL_ZRFC_READ_TABLE2; however, when trying to use it from ADF with the SAP connector (version 3.0.23 64bit) we get an error.

Type: SAP.Middleware.Connector.RfcInvalidParameterException

Message: Element QUERY_TABLE of container metadata XXXXX/ZFM_INTERNAL_ZRFC_READ_TABLE2 unknown.

I posted this question in the GitHub feedback page (link) and was told this is a better forum to answer this type of questions.

The FM has the QUERY_TABLE parameter and it has been tested to be working (using Python scripts). Screenshots of the configuration and tests performed.

FM Config

Test Configuration

Test Results

Any ideas where the problem could be? Thanks in advance for your help!

I am trying to do a course for fetching xml data with python but even though I follow the tutorial I keep getting a 10054 error. What am I doing wrong?