web scrapping to JSon in google sheets

Job ID: 37049515

Budget: $10 – $30 USD

Hi
I have a website, which need scraping, below is the data.

https://www.**.com/enquiries?culture=en#detailView

Container number TLLU1141519
(also have other number dfou6118807)
Select most recent with "XF"
Get data in Json in google sheets (just need json not to be formated)

Replace ** with K I C T L

I have script which is partially working