How to load a json file in pyspark with colon character in file name

[laus]

Hi,

I'm trying to load this json file which contains the colon character in its name: file_name.2022-03-05_11:30:00.json but I get the error in screenshot below saying that there is a relative path in an absolute url -

Any idea how to read this file?

file_name = file_name.2022-03-05_11:30:00.json

Thanks for your help in advance!

[User16741082858]

Hi @Laura Blancarte​ . Have you tried saving the file path to a list?

[laus]

Hi @Pearl Ubaru​ ,

Thanks for your reply.

Yes, I have a list of path files through which I loop and try to load the file at the current index but I get the same error about there being a relative path. Am I missing something?

Ty!

[User16741082858]

Is it okay if I see a bit more of your code? Preferably the list and loop?

[laus]

@Pearl Ubaru​ , Sure, here it is:

[User16741082858 · Accepted solution]

Hi @Laura Blancarte​ , I apologize for the late response... Try replacing the colons in the file name with %3A. This will work by replacing the colons with URL encoded format.

[Kaniz_Fatma]

Hi @Laura Blancarte​ , Just a friendly follow-up. Do you still need help, or @Pearl Ubaru​ 's response help you to find the solution? Please let us know.

[Noopur_Nigam]

Hi @Laura Blancarte​ I hope that @Pearl Ubaru​'s answer would have helped you in resolving your issue.Please let us know if you need more help on this.