Alteryx IO Discussions

Customize and extend the power of Alteryx with SDKs, APIs, custom tools, and more.

The Designer x64 reported: InboundNamedPipe GetOverlappedResult: The pipe has been ended.

mikebijl
6 - Meteoroid

Hi all,

 

Some context: we are building a custom tool for Alteryx Designer with the Platform SDK. We had an integration, but due to some issues with the first version of the Python SDK we have to migrate to V2. So currently we are in the process of manually migrating, this with the documentation.

 

One difference is writing to an output anchor. Previously this was done with RecordPackets and we could display some null values in the output table, as shown in following screenshot:

 

Screenshot 2022-05-11 at 15.53.50.png

 

Whilst migrating we had to transfer to use a pyarrow.Table instead. Converting to such table goes as expected. However when this table is written to an output anchor we get following error:

The Designer x64 reported: InboundNamedPipe GetOverlappedResult: The pipe has been ended.

 

Screenshot 2022-05-11 at 16.02.51.png

 

By testing and searching what causes this issue, we found that this occurs when the table includes 'None' values. We managed to work around this by converting None values to strings 'None'. Following conversion is a workaround:

 

def convert_none_values(dictionary: Dict) -> Dict:
    return {key:value if value is not None else 'None' for (key, value) in dictionary.items()}

 

 

Screenshot 2022-05-11 at 16.05.58.png

 

As you can see, updatedAt is now a string 'None' which we would like to be [null] as before, because once more: it is workaround we would like to get rid of ASAP.

 

We think the 'InboundNamedPipe GetOverlappedResult: The pipe has been ended' is a bug in the first place.

We would love any feedback.

 

Thanks in advance!

Mike

0 REPLIES 0