filebot and sonarr import again

[KRONZO]

Hi Rednoah

I've decided to try and fix this my patch got to be to annoying.
Im trying to get sonarr to import files renamed by filebot, you helped me a little earlier this year.
viewtopic.php?p=31795#p31795
i've gotten filebot to pass the name to the import script i think, but my best result is, that nothing throws an error but no import happens, I think i need a path variable in the import code but i do not know what and im not sure FB is passing the path correctly so i'm hoping you can help me again.

this is what --def exec calls (i think i need something in path) (running on windows 10)

Code: Select all

$url = "http://localhost:2587/api/command"
$json = '{"name": "downloadedepisodesscan","path": "" , "importMode":"Move"}' 

Write-Host "Publishing update $version ($branch) to: $url"
Invoke-RestMethod -Uri $url -Method Post -Body $json -Headers @{"X-Api-Key"="4dd3cc179te04d15kt9288313d8d21087d"}

and the FB test AMC

Code: Select all

filebot -script fn:amc --output "D:/tempdir" --action hardlink -non-strict --def seriesFormat="{fn}/{fn}" "D:/testmedia"  --def exec="D:\testmedia\sonarrimport.ps1 {quote f}"

and finally the output

as you can see there is nothing in path in the picture, when i manually insert path everything works

Thank you in advance

[rednoah]

The command looks good to me. The issue is likely in your script. You can add some debugging information to your script to find out what's going on.


1.
This definitely won't work, since you'll probably want the file path of your Argument 1 here:

Code: Select all

"path": ""

2.
When you send a request, the request will give you a response. You'll want to print this response, so that you can read the error message that sonarr is giving you back for bad requests.


3.
Generating valid json can be tricky. Use this:
https://stackoverflow.com/a/44597342/1514467

[KRONZO]

Hi Rednoah
Yeah i figured i need to pass the filebot path to the "path": "" but i have no idea how to, i've tried $filepath and all the variants i could find.
I dont know how to use what you linked to, i've spent days and hours on this and is at an impasse (isn't there some kind of wildcard to catch the path fb is sending)

[rednoah]

Well, presumably, a PowerShell tutorial on how to use variables and Strings will hold the solution.

Here's a --def exec expression that should work:

Code: Select all

Invoke-RestMethod -Uri 'http://localhost:2587/api/command' -Method Post -Body {quote groovy.json.JsonOutput.toJson(name: 'downloadedepisodesscan', path: f.path , importMode: 'Move')} -Headers @{'X-Api-Key'='4dd3cc179te04d15kt9288313d8d21087d'}

Does not use any "..." so you can use --def exec="..." without having to escape "..." characters.

Does use groovy.json.JsonOutput to generate valid json text.

You'll want to print the response as well, so read this https://stackoverflow.com/a/40703109/1514467 and modify the command accordingly.

[KRONZO]

Thank you a lot for your help on this.
I tried this

Code: Select all

Invoke-RestMethod -Uri 'http://localhost:2587/api/command' -Method Post -Body {quote groovy.json.JsonOutput.toJson(name: 'downloadedepisodesscan', path: f.path , importMode: 'Move')} -Headers @{'X-Api-Key'='4dd3cc179te04d15kt9288313d8d21087d'}

unfortunately it gave an error in both powershell and sonarr
powershell.

Execute: D:\testmedia\sonarrimport.ps1 @'
D:\tempdir\judge.judy.s23e10.when.the.marine.is.away.the.gun.is.in.play.he.likes.it.hot.720p.hdtv.x264-w4f\judge.judy.s23e10.when.the.marine.is.away.the.gun.is.in.play.he.likes.it.hot.720p.hdtv.x264-w4f.mkv
'@
Invoke-RestMethod : The remote server returned an error: (500) Internal Server Error.
At D:\testmedia\sonarrimport.ps1:1 char:1
+ Invoke-RestMethod -Uri 'http://localhost:9595/api/command' -Method Po ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebExc
eption
+ FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeRestMethodCommand

and in sonarr

Request Failed. POST /api/command: Unexpected character encountered while parsing value: q. Path '', line 0, position 0. (Json snippet '<--error-->quote groovy.json.Js')

exeption

Newtonsoft.Json.JsonReaderException: Unexpected character encountered while parsing value: q. Path '', line 0, position 0. (Json snippet '<--error-->quote groovy.json.Js') ---> Newtonsoft.Json.JsonReaderException: Unexpected character encountered while parsing value: q. Path '', line 0, position 0.
at Newtonsoft.Json.JsonTextReader.ParseValue()
at Newtonsoft.Json.JsonTextReader.Read()
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.ReadForType(JsonReader reader, JsonContract contract, Boolean hasConverter)
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent)
at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType)
at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings)
at NzbDrone.Common.Serializer.Json.Deserialize(String json, Type type) in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Common\Serializer\Json.cs:line 52
--- End of inner exception stack trace ---
at NzbDrone.Common.Serializer.Json.Deserialize(String json, Type type) in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Common\Serializer\Json.cs:line 56
at NzbDrone.Api.Extensions.ReqResExtensions.FromJson(Stream body, Type type) in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Api\Extensions\ReqResExtensions.cs:line 31
at NzbDrone.Api.Extensions.ReqResExtensions.FromJson[T](Stream body, Type type) in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Api\Extensions\ReqResExtensions.cs:line 24
at NzbDrone.Api.Extensions.ReqResExtensions.FromJson[T](Stream body) in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Api\Extensions\ReqResExtensions.cs:line 19
at NzbDrone.Api.REST.RestModule`1.ReadResourceFromRequest(Boolean skipValidate) in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Api\REST\RestModule.cs:line 188
at NzbDrone.Api.REST.RestModule`1.<set_CreateResource>b__41_0(Object options) in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Api\REST\RestModule.cs:line 155
at CallSite.Target(Closure , CallSite , Func`2 , Object )
at Nancy.Routing.Route.<>c__DisplayClass4.<Wrap>b__3(Object parameters, CancellationToken context)

[rednoah]

Does not use any "..." so you can use --def exec="..." without having to escape "..." characters.

You'll want to print the response as well, so read this https://stackoverflow.com/a/40703109/1514467 and modify the command accordingly.

YES:

Code: Select all

filebot ... --def exec="Invoke-RestMethod -Uri 'http://localhost:2587/api/command' -Method Post -Body {quote groovy.json.JsonOutput.toJson(name: 'downloadedepisodesscan', path: f.path , importMode: 'Move')} -Headers @{'X-Api-Key'='4dd3cc179te04d15kt9288313d8d21087d'} | Select-Object -Expand Content"

We avoid using PS1 scripts because neither of us is any good at writing PS1 scripts.


NO:

Code: Select all

filebot ... --def exec="D:\testmedia\sonarrimport.ps1 {quote f}"

The problem isn't FileBot. The problem is not knowing how to write PS1 scripts, therefore encapsulating all the tricky parts in the PS1 script ain't exactly a good idea.

[KRONZO]

I thank you again
(also for the laugh)

We avoid using PS1 scripts because neither of us is any good at writing PS1 scripts.

this time it gives an filebot error regarding api key

SyntaxError:
[X-Api-Key] is a constant expression, but it should be a variable expression at line: 1 column: 12. File: Script3.groovy
javax.script.ScriptException: SyntaxError:
[X-Api-Key] is a constant expression, but it should be a variable expression at line: 1 column: 12. File: Script3.groovy
at net.filebot.format.ExpressionFormat.compile(ExpressionFormat.java:85)
at net.filebot.format.ExpressionFormat.<init>(ExpressionFormat.java:43)
at net.filebot.cli.ScriptShellBaseClass.getMediaInfo(ScriptShellBaseClass.java:237)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at Script1$_run_closure56.doCall(Script1.groovy:526)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at Script1.run(Script1.groovy:526)
at net.filebot.cli.ScriptShell.evaluate(ScriptShell.java:64)
at net.filebot.cli.ScriptShell.runScript(ScriptShell.java:74)
at net.filebot.cli.ArgumentProcessor.runScript(ArgumentProcessor.java:154)
at net.filebot.cli.ArgumentProcessor.run(ArgumentProcessor.java:36)
at net.filebot.Main.main(Main.java:127)

Failure (°_°)

[rednoah]

We learn that FileBot is interpreting the @{key=value} bit because FileBot by design interprets {...} bits as Groovy code.

Therefore we apply some trickery and write Groovy code that prints PS1 code:

Code: Select all

-Headers { /@{'X-Api-Key'='4dd3cc179te04d15kt9288313d8d21087d'}/ }

[KRONZO]

I'm sorry now we are back to the path problem again ;(

Sonarr

Request Failed. POST /api/command: Unexpected character encountered while parsing value: d. Path 'name', line 1, position 7. (Json snippet '{name:d<--error-->ownloadedepisodessca')

Code: Select all

Newtonsoft.Json.JsonReaderException: Unexpected character encountered while parsing value: d. Path 'name', line 1, position 7. (Json snippet '{name:d<--error-->ownloadedepisodessca') ---> Newtonsoft.Json.JsonReaderException: Unexpected character encountered while parsing value: d. Path 'name', line 1, position 7.
   at Newtonsoft.Json.JsonTextReader.ReadStringValue(ReadType readType)
   at Newtonsoft.Json.JsonTextReader.ReadAsString()
   at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.ReadForType(JsonReader reader, JsonContract contract, Boolean hasConverter)
   at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.PopulateObject(Object newObject, JsonReader reader, JsonObjectContract contract, JsonProperty member, String id)
   at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObject(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)
   at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateValueInternal(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)
   at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent)
   at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType)
   at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings)
   at NzbDrone.Common.Serializer.Json.Deserialize(String json, Type type) in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Common\Serializer\Json.cs:line 52
   --- End of inner exception stack trace ---
   at NzbDrone.Common.Serializer.Json.Deserialize(String json, Type type) in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Common\Serializer\Json.cs:line 56
   at NzbDrone.Api.Extensions.ReqResExtensions.FromJson(Stream body, Type type) in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Api\Extensions\ReqResExtensions.cs:line 31
   at NzbDrone.Api.Extensions.ReqResExtensions.FromJson[T](Stream body, Type type) in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Api\Extensions\ReqResExtensions.cs:line 24
   at NzbDrone.Api.Extensions.ReqResExtensions.FromJson[T](Stream body) in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Api\Extensions\ReqResExtensions.cs:line 19
   at NzbDrone.Api.REST.RestModule`1.ReadResourceFromRequest(Boolean skipValidate) in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Api\REST\RestModule.cs:line 188
   at NzbDrone.Api.REST.RestModule`1.<set_CreateResource>b__41_0(Object options) in C:\BuildAgent\work\5d7581516c0ee5b3\src\NzbDrone.Api\REST\RestModule.cs:line 155
   at CallSite.Target(Closure , CallSite , Func`2 , Object )
   at Nancy.Routing.Route.<>c__DisplayClass4.<Wrap>b__3(Object parameters, CancellationToken context)

Code: Select all

Invoke-RestMethod : The remote server returned an error: (500) Internal Server Error.
At line:1 char:1
+ Invoke-RestMethod -Uri 'http://localhost:9595/api/command' -Method Po ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebException
    + FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeRestMethodCommand

[rednoah]

So what's the command that is executed?

The Execute part of the log will tell us more:

Code: Select all

Execute: <the command that is executed>

Check if the json structure we send is the json structure sonarr expects.

[KRONZO]

ok now you are asking me to work for my food I will enable the log and be back

[KRONZO]

Code: Select all

Execute: Invoke-RestMethod -Uri 'http://localhost:9595/api/command' -Method Post -Body @'
{"name":"downloadedepisodesscan","path":"D:\\tempdir\\judge.judy.s23e10.when.the.marine.is.away.the.gun.is.in.play.he.likes.it.hot.720p.hdtv.x264-w4f\\judge.judy.s23e10.when.the.marine.is.away.the.gun.is.in.play.he.likes.it.hot.720p.hdtv.x264-w4f.mkv","importMode":"Move"}
'@ -Headers @{'X-Api-Key'='4dd3cc179fe04d7313d8d21087d'} | Select-Object -Expand Content
Execute: Invoke-RestMethod -Uri 'http://localhost:9595/api/command' -Method Post -Body @'
{"name":"downloadedepisodesscan","path":"D:\\tempdir\\judge.judy.s23e11.oh.how.i.wish.i.hadnt.taken.that.nude.photo.of.myself.720p.hdtv.x264-w4f\\judge.judy.s23e11.oh.how.i.wish.i.hadnt.taken.that.nude.photo.of.myself.720p.hdtv.x264-w4f.mkv","importMode":"Move"}
'@ -Headers @{'X-Api-Key'='4dd3cc179fe04d78928d8d21087d'} | Select-Object -Expand Content
Execute: Invoke-RestMethod -Uri 'http://localhost:9595/api/command' -Method Post -Body @'
{"name":"downloadedepisodesscan","path":"D:\\tempdir\\Movies\\The Spy Who Dumped Me (2018)\\The Spy Who Dumped Me (2018).mkv","importMode":"Move"}
'@ -Headers @{'X-Api-Key'='4dd3ccd789288313d8h456454hp5d21087d'} | Select-Object -Expand Content

the execute part of the log I can't see anything wrong, but why would I i'm not very good at this

[rednoah]

Looks good to me. Json Formatter says it's VALID JSON. So that means Sonarr fails to parse valid json, which means you'll need to go to the Sonarr forums, report this as a bug, and ask for a fix or a workaround.

[KRONZO]

fair enough.
thank you for your excellent Support, I am very grateful for all your help

[KRONZO]

hi Again
i'm hoping for one more try
the guys over at sonarr says it will work if i only pass the folder name and not the file, is this possible ?

[rednoah]

Sure, replace f.path with folder.path in your --def exec expression.

[KRONZO]

jesus christ
thank you I would have started to mess around with the quote f

;D

[ZeroByDivide]

If you would like, I've created an import script for sonarr and radarr a while back with the help from rednoah and it works wonders.

You can find it here https://github.com/JourneyOver/filebot

File is called "Update_Sonarr_Radarr.groovy", just download said file then go in and edit the "PLACEAPIKEYHERE" bit with your API. If you don't want to use radarr bit for the script you can either comment it out or just remove it entirely up to you.

Executive call you'd place in your normal filebot script to call said import script would be "exec=filebot -script /path/to/Update_Sonarr_Radarr.groovy --def type={type} id={id}"

[Muddro]

If you would like, I've created an import script for sonarr and radarr a while back with the help from rednoah and it works wonders.

You can find it here https://github.com/JourneyOver/filebot

File is called "Update_Sonarr_Radarr.groovy", just download said file then go in and edit the "PLACEAPIKEYHERE" bit with your API. If you don't want to use radarr bit for the script you can either comment it out or just remove it entirely up to you.

Executive call you'd place in your normal filebot script to call said import script would be "exec=filebot -script /path/to/Update_Sonarr_Radarr.groovy --def type={type} id={id}"

Can you emxplain to me how this works? I have been going nuts trying to find a solution for rar'd files and sonarr/radarr. Do I need to mess with the extraction location in my amc script?

[ZeroByDivide]

If you would like, I've created an import script for sonarr and radarr a while back with the help from rednoah and it works wonders.

You can find it here https://github.com/JourneyOver/filebot

File is called "Update_Sonarr_Radarr.groovy", just download said file then go in and edit the "PLACEAPIKEYHERE" bit with your API. If you don't want to use radarr bit for the script you can either comment it out or just remove it entirely up to you.

Executive call you'd place in your normal filebot script to call said import script would be "exec=filebot -script /path/to/Update_Sonarr_Radarr.groovy --def type={type} id={id}"

Can you emxplain to me how this works? I have been going nuts trying to find a solution for rar'd files and sonarr/radarr. Do I need to mess with the extraction location in my amc script?

Sent you a PM explaining on how to set things up. Sorry I didn't really set up a readme or anything to explain really on the repository. I'll eventually get one set up, but time right now is kinda not on my side becuase I'm busy trying to find a job/place to live due to both my parents passing away this month and other irl circumstances going on.

[Muddro]

If you would like, I've created an import script for sonarr and radarr a while back with the help from rednoah and it works wonders.

You can find it here https://github.com/JourneyOver/filebot

File is called "Update_Sonarr_Radarr.groovy", just download said file then go in and edit the "PLACEAPIKEYHERE" bit with your API. If you don't want to use radarr bit for the script you can either comment it out or just remove it entirely up to you.

Executive call you'd place in your normal filebot script to call said import script would be "exec=filebot -script /path/to/Update_Sonarr_Radarr.groovy --def type={type} id={id}"

Can you emxplain to me how this works? I have been going nuts trying to find a solution for rar'd files and sonarr/radarr. Do I need to mess with the extraction location in my amc script?

Sent you a PM explaining on how to set things up. Sorry I didn't really set up a readme or anything to explain really on the repository. I'll eventually get one set up, but time right now is kinda not on my side becuase I'm busy trying to find a job/place to live due to both my parents passing away this month and other irl circumstances going on.

Thanks. Just came back here, but had it working. Very much appreciate the hard work you put into this. I do have a question though on a possible modification. Currently this works fine but is limited to one instance of radarr and sonarr. Some people run a second instance of each for 4k stuff. Is there a way to have it trigger for normal stuff a certain instance of sonarr, and another for 4k items?

[ZeroByDivide]

Can you emxplain to me how this works? I have been going nuts trying to find a solution for rar'd files and sonarr/radarr. Do I need to mess with the extraction location in my amc script?

Sent you a PM explaining on how to set things up. Sorry I didn't really set up a readme or anything to explain really on the repository. I'll eventually get one set up, but time right now is kinda not on my side becuase I'm busy trying to find a job/place to live due to both my parents passing away this month and other irl circumstances going on.

Thanks. Just came back here, but had it working. Very much appreciate the hard work you put into this. I do have a question though on a possible modification. Currently this works fine but is limited to one instance of radarr and sonarr. Some people run a second instance of each for 4k stuff. Is there a way to have it trigger for normal stuff a certain instance of sonarr, and another for 4k items?

Sent you another PM, hopefully it works for you but I'm not sure. :s